> 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 ____ • 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.
