[wplug] OT: Any MySQL gurus? Quick easy question..

[Joe]

techmike wrote:

>PHP is my prefrence, but since this is for work I am stuck with
>Coldfusion..  :(
>
>I considered storing the value as MMDDYY and just plug in the hypens when
>I output the info..
>
>Since I'm probably going to be the only one to actually use the finished
>template I'm not too worried about people-proofing it..  :)
>
>-mike
>
>  
>
>>Just a little tip.  When ever I am working with dates I try to use the
>>following format.
>>yyyymmdd
>>
>>This makes searching a lot easier.  I ran into a few problems using
>>mm-dd-yy.  Now I just have a php function that will take a date from
>>either mm-dd-yy or mm-dd-yy and convert it to yyyymmdd and the other
>>way
>>for displaying.
>>
>>Chris Romano
>>
>>
>>_______________________________________________
>>wplug mailing list
>>wplug at wplug.org
>>http://www.wplug.org/mailman/listinfo/wplug
>>    
>>
>
>
>_______________________________________________
>wplug mailing list
>wplug at wplug.org
>http://www.wplug.org/mailman/listinfo/wplug
>
>  
>
There are a lot of coldfusion date functions:
http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/functions-pt09.htm#1098968
I use those for the displaying and store dates as suggested by Chris.



========================================================================
CONFIDENTIALITY NOTICE
----------------------
This message, together with any attachments, may be legally privileged
and is confidential information intended only for the use of the
individual or entity to which it is addressed.  It is exempt from
disclosure under applicable law including court orders.  If you are not
the intended recipient, you are hereby notified that any use,
dissemination, distribution or copy of this message, or any attachment,
is strictly prohibited.  If you have received this message in error,
please notify the original sender and delete this message, along with
any attachments, from your computer.