Mailing-List: list azipa@egroups.com; contact azipa-owner@egroups.com
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==