> > Is this then the line for, say March 10?
> >
> > SELECT DATE('0-03-10 10:03:0') FROM etc;
> > which is applied directly to the DATE column, no prior conversion?
>
> i doubt it, unless you have people in your table who were born on the 10th
of
> march in the year zero
>
> ;o)
>
> first of all, what database are you using? i know you must've mentioned
it, but
> you are putting the onus on people to remember (not a safe bet in my case)
>
> secondly, how are birthdays stored? date or datetime format? or using
unix
> timestamps like 37429200, 69051600, 100674000? (note: only two of these
three
> examples are march 10th -- can you spot the one that isn't? this
conveniently
> illustrates my point that not all instances of a unix timestamp are
manipulated
> with a programming language, unless your email program happens to have
smarts
> built in to screen message body text for large integers and automatically
> convert them)
>
> by the way, unix timestamps are only good for 1970 and on, so your table
had
> better not have anybody in it who is over 35
>
>
> rudy
rudy,
I had noted the 1970 limitation with unix timestamps; thanks for the
confirmation - that does count it out.
This is on MySQL with php (both local and the host) and at the moment I have
Date as the field type as I have no use for the time of day (I'm not
offering horoscopes).
And no, I can't spot the meaning of the unix seconds, though I wonder if the
last, with all its noughts - or zeros if you must, is marching to a
different beat. :o(
Joseph
____ • The WDVL Discussion List from WDVL.COM • ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To: [email protected]
To change subscription settings, add a password or view the web interface:
http://intm-dl.sparklist.com/read/?forum=wdvltalk
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.
