datetime is just this:
strftime('%Y-%m-%d %H:%M:%S', ...)
>From http://www.sqlite.org/lang_datefunc.html
><http://www.sqlite.org/lang_datefunc.html>
And that doesn't do what you want...you need strftime to get just the year.
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Northrop Grumman Information Systems
________________________________
From: [email protected] on behalf of J. Bobby Lopez
Sent: Wed 9/29/2010 11:46 AM
To: General Discussion of SQLite Database
Subject: EXTERNAL:Re: [sqlite] Getting unique years from a timestamp column
I guess a follow-on question here would be, which function should I be using
more often, the datetime() function, or the strftime()? I didn't think that
the datetime() function accepted the format argument (%Y) like strftime()
did.
On Wed, Sep 29, 2010 at 12:42 PM, J. Bobby Lopez <[email protected]> wrote:
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
