[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] Convert the CURRENT_TIMESTAMP
From:       Harold Wood & Meyuni Gani <hwoody2wood () yahoo ! com>
Date:       2008-07-25 23:41:59
Message-ID: 20080725234335.E5EA8119EB () sqlite ! org
[Download RAW message or body]

Look at the wiki for date/time functions, specifically strft.

Woody
from his pda

-----Original Message-----
From: Joanne Pham <joannekpham@yahoo.com>
Sent: Friday, July 25, 2008 4:08 PM
To: General Discussion of SQLite Database <sqlite-users@sqlite.org>; cj_holbrook@yahoo.co.uk
Subject: [sqlite] Convert the CURRENT_TIMESTAMP

Hi All,
I ran the following sql statement
select CURRENT_TIMESTAMP;
and the output is :
2008-07-25 23:11:13
Is there any easy way or buildin function to convert this format to :
TUE JULY 25 23:11:13 2008
Thanks,
JP



_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



      
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[prev in list] [next in list] [prev in thread] [next in thread]