Re: [Phpwebsite-developers] dates

[<php...@li...>]

For calendar I use 4 characters for time (1330 : 1 o'clock) and 8 for date
(20021115 : Nov 15, 2002).

That's just me though.

For tracking specific times, I use mktime()

Matt


> I haven't done a whole lot of research there.  I normally use the
> datetime type but that could be mysql specific.  One would think that
> timestamp would be uniform across the board, but I would have to do some
> testing to be sure.  I will try to come up with a real answer for you
> Don :)
>
> Adam
>
>> In my module I want to store dates.  I'm wondering if there is a
>> sql-standard date field.  I've seen and used various datatypes like
>> date,  datetime, timestamp, etc.  Is there one that is standard across
>> databases?
>>
>> Otherwise I could store month, date, and year as varchar fields and
>> then
>>  just use php to create a php date object for manipulation.
>>
>> Don.
>>
>>
>>
>> -------------------------------------------------------
>> This sf.net email is sponsored by: To learn the basics of securing
>> your web site with SSL, click here to get a FREE TRIAL of a Thawte
>> Server Certificate: http://www.gothawte.com/rd524.html
>> _______________________________________________
>> Phpwebsite-developers mailing list
>> Php...@li...
>> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
>
>
> ---------------------------------
> Adam Morton
> Developer - Electronic Student Services
> http://phpwebsite.appstate.edu
> Founder - ASU Linux Users Group
> http://alug.appstate.edu
>
>
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by: To learn the basics of securing  your
> web site with SSL, click here to get a FREE TRIAL of a Thawte  Server
> Certificate: http://www.gothawte.com/rd524.html
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers


Matthew McNaney
Internet Systems Architect
Electronic Student Services
Email: ma...@tu...
URL: http://phpwebsite.appstate.edu
Phone: 828-262-6493
ICQ: 141057403