i think i got it.
echo date("M-d-Y H:i:s", mktime());
date() is php.
thanks.
dotolee wrote:
>
> 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-tp33189769p33190888.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
