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" <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
_______________________________________________
use-revolution mailing list
[email protected]
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
- - - - - - - - - - - -
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
