Trent,
He's actually trying to ''stamp'' the column with only the date. I don't
believe that is possible in oracle or SQL. Regardless of what is in a
date/time column, it can be read/displayed any way you wish.
I believe he is really asking how to display only the date in a column, is
that correct Justin?
-----Original Message-----
From: Trent Shipley [mailto:tshipley@symbio-tech.com]
Sent: Friday, December 29, 2000 12:16 PM
To: Justin Wilson; azipa@egroups.com
Subject: RE: [azipa] SQL question
That can be specific to the SQL implementation.
In Oracle use the TO_CHAR() function.
For example:
SELECT TO_CHAR(some_date_column, "YYYY-MON-DD") FROM some_table
/
> -----Original Message-----
> From: Justin Wilson [mailto:justin@labxpress.com]
> Sent: Friday, December 29, 2000 12:17 PM
> To: 'azipa@egroups.com'
> Subject: [azipa] SQL question
>
>
> I have a simple SQL question for anyone that knows SQL. I am
> trying to time
> date stamp entries that are made through one of our websites, Currently I
> have it using date and time stamp. Is there a way to stamp these entries
> with just the date?
>
> -Justin
> justin@labxpress.com
>
==AZIPA=============================================================
Arizona Internet Professionals Association http://www.azipa.org
Next AZIPA monthly meeting is 5:30pm on Monday, January 22nd, 2001
Please be sure to RSVP! http://www.acteva.com/go/azipa
Other upcoming events:
Tempe Tech Oasis Techie Tuesday - 6:00pm, Tuesday 1/9/01
Beeloe's Cafe & Bar, 501 S. Mill Ave Tempe (SE corner of 5th)
Strategic Research Institute Web Launch BootCamp - 1/30-2/2/01
http://www.srinstitute.com/cx326
=============================================================AZIPA==
==AZIPA=============================================================
Arizona Internet Professionals Association http://www.azipa.org
Next AZIPA monthly meeting is 5:30pm on Monday, January 22nd, 2001
Please be sure to RSVP! http://www.acteva.com/go/azipa
Other upcoming events:
Tempe Tech Oasis Techie Tuesday - 6:00pm, Tuesday 1/9/01
Beeloe's Cafe & Bar, 501 S. Mill Ave Tempe (SE corner of 5th)
Strategic Research Institute Web Launch BootCamp - 1/30-2/2/01
http://www.srinstitute.com/cx326
=============================================================AZIPA==
