But MySQL uses yyyy-mm-dd (which may be where Sivakatirswami is
running into it?), and I think other SQLs do too. Not a bad thing to
have Rev's dates conform to . . .
On the other hand, changing the documented form of dates sounds like
a blueprint for a trail of broken apps.
Maybe a built-in date-conversion function, with different standards
as arguments controlling the output? It would be *great* to have a
smart function like that, that would take the whole range of formats
various users might type into a field. (Anybody got one?)
Charles Hartman
On Oct 14, 2005, at 6:26 PM, Mark Smith wrote:
I've seen quite a lot of YYYYMMDD about, what Sarah calls 'numeric
date' in her DateTime library. I've been using it in all my apps
internally for ages, since it's so easy to sort and search. I have
a few of simple functions to convert back and forth, and identify
weekends and such like, though I've got so used to it that for
myself, I'm just as comfortable seeing 20051014 as 14/10/05...
Mark
On 14 Oct 2005, at 23:14, Alex Tweedly wrote:
Sivakatirswami wrote:
Anyone want to vote for a new standard date format?
YYYY-MM-DD
In fact I believe the above is some standard now...
ISO 8601
I find myself more and more encountering this as input from
systems both of my own creation and from others...
Now you have to do a little dance to get that into a convertable
string...or am I missing something
input: e.g.
06/04/13 tab someData tab SomeMoreData etc
set the itemdel to tab
put item 1 of line 1 into tDate
set the itemdel to "/"
put "/" & item 1 of tDate after tDate
delete item 1 of tDate
set the itemdel to tab
It's "fixed format" isn't it (in this case, YY/MM/DD), so could
you just do
put line 1 into tLine
put char 4 to 8 of tLine & "/" & char 1 to 2 of tLine into item 1
of tLine
--
Alex Tweedly http://www.tweedly.net
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.14/131 - Release Date:
12/10/2005
_______________________________________________
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
_______________________________________________
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
_______________________________________________
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
