Correct. The ISO strings are the de-facto standard since that's what all the
date and time functions take in.
http://www.sqlite.org/lang_datefunc.html
"The strftime() routine returns the date formatted according to the format
string specified as the first argument."
It's there so you can store your datetimes in a standardized way, then display
them however you or your user wants, be it
"03/07/2017"
"3/7/17"
"7-Mar-2017"
"20170307"
"March 7, 2017 AD"
"The 7th day of the third month of the 17th year of the reign of Tiberius
Caesar"
The last one would be more in line with the modifiers you can use.
strftime('%m/%d/%Y', TiberiusCaesar, 'start of reign', '+17 years', 'start of
year', '+3 months', '+7 days')
-----Original Message-----
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of Jens Alfke
Sent: Wednesday, March 08, 2017 3:04 PM
To: SQLite mailing list
Subject: Re: [sqlite] Why isn't my time formatting working?
> On Mar 8, 2017, at 11:59 AM, Rob Richardson <rdrichard...@rad-con.com> wrote:
>
> Given the lack of an indication of the return type, it seemed to me to be
> reasonable to assume that since I'm passing in a string as one of the
> arguments, I'd get a datetime object out.
SQLite doesn’t have a datetime type, as far as I know. Dates are stored as
strings.
—Jens
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
