New date format: YYYY-MM-DD

[Stephen Barncard]

ok, Ken then

function  sqbDateTime
   get the long time
   convert it to dateitems
   set the numberformat to "00"
   return¬
   (item 1 of it)+0 & "-" & (item 2 of it)+0 & "-" & (item 3 of it)+0  &&¬
   (item 4 of it)+0 & ":" & (item 5 of it)+0 & ":" & (item 6 of it)+0
end  sqbDateTime

This returns the Date Time format that MySQL likes for a dateTime field:

2005-10-14 23:34:15





>On 10/14/05 8:02 PM, "Stephen Barncard" <stephenREVOLUTION at barncard.com>
>wrote:
>
>>>  Anyone want to vote for a new standard date format?
>>>
>>>  YYYY-MM-DD
>>
>>  The numbers come right in line with the Dateitmes conversion...
>
>Yes, but unfortunately the dateItems aren't zero-padded, so for May 5, 2005
>you get:
>
>    2005,5,5
>
>instead of
>
>   2005,05,05
>
>I'd love to see an additional "ISO" conversion format:
>
>   convert tDate to ISO date
>   convert tTime to ISO time
>
>Mark Waddingham - any chance of getting this into 2.7?
>
>:-)
>
>Ken Ray
>Sons of Thunder Software
>Web site: http://www.sonsothunder.com/
>Email: kray at sonsothunder.com
>
>
>
>_______________________________________________
>use-revolution mailing list
>use-revolution at lists.runrev.com
>Please visit this url to subscribe, unsubscribe 
>and manage your subscription preferences:
>http://lists.runrev.com/mailman/listinfo/use-revolution


-- 
stephen barncard
s a n  f r a n c i s c o
- - -  - - - - - - - - -