It seems to me these are not separate functions at all, just aliases to strftime(). I guess the work well as shortcuts in certain situations.
Thanks for the assistance! Bobby On Wed, Sep 29, 2010 at 12:48 PM, Black, Michael (IS) < [email protected]> wrote: > 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 > > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
