I believe if you take a look in the wiki, you will find the date and time functions. Otherwise, look through the syntax section and the wiki section of the web site.
Bob Dankert -----Original Message----- From: John Mistler [mailto:[EMAIL PROTECTED] Sent: Thursday, October 14, 2004 4:47 PM To: [EMAIL PROTECTED] Subject: [sqlite] Documentation help I am new to SQLite and am trying to gather more detailed information about the available functions and syntax than what it set out in the "Syntax" page. One example would be: Where can I find out how to return a date from a datetime column in the format "12/24/2004 08:45:23 PM" rather than "2004-12-24 20:45:23"? Can someone lead me to this TYPE of documentation? Is there a searchable SQLite documentation database? Thanks, John
