i'm storing as integers now in the database.
getting the unix time in seconds using the mktime() method.
now i just need to figure out how to display properly.
for example, in the sample below, i'm having a hard time getting the minutes
to show up as minutes. right now, the "m" is displaying the month.
echo date("M-d-Y H:m:s", mktime());
i've read http://www.sqlite.org/lang_datefunc.html but i can't seem to get
it to work.
Simon Slavin-3 wrote:
>
>
> On 23 Jan 2012, at 5:53pm, Stephan Beal wrote:
>
>> On Mon, Jan 23, 2012 at 6:51 PM, dotolee <[email protected]> wrote:
>>
>>> i'm new to sqlite... and relatively new to php. just wondering what the
>>> best way is to store and compare dates.
>>
>> For any given 10 developers you'll likely hear 11 opinions on this topic.
>
> How true. For what it's worth, here's mine:
>
> 1) read
>
> http://www.sqlite.org/lang_datefunc.html
>
> 2) If you need to do maths on dates (how many days apart are two dates,
> what's three days after this date, etc.) store your dates as numbers,
> either julianday or unixepoch.
>
> 3) Otherwise store them as text, in YYYYMMDD format, so they're easy to
> read when you're debugging.
>
> Simon.
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
--
View this message in context:
http://old.nabble.com/storing-and-comparing-dates-in-sqlite-tp33189769p33190861.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
