New date format: YYYY-MM-DD

[Charles Hartman]

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
>> 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
>>
>>
>
> _______________________________________________
> 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
>