===================================== archive: RE: [azipa] SQL question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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==


Tue Jan 6, 12:47 am