>>> On 6/13/2006 at 5:38 am, in message <[EMAIL PROTECTED]>, [EMAIL PROTECTED] wrote: > Brian, > [snipped...] > As far as ISO conversion goes - here's a hypothetical question for > you: If 2 book orders came in from the web each for 1 "Da Vinci Code", > you only have 1 in stock, which order gets priority? The one dated > 2006-04-30T02:56:32+11:00 or the other dated > 2006-04-29T11:56:32-05:00? > > That's right, you have to cut the book in half... even though one > order was dated the 30^th and the other the 29^th they were raised at > exactly the same moment in time (spooky music plays - camera pans to > cryptic symbols ...) and have the same temporal priority. The fact > that ISO date time is a recognised international standard and is used > extensively in XML, is "language" and OS independent and that it > DOESN'T separate date and time is actually something I wish Pick did > better. It is functionality that IBM already have in other products > and could easily incorporate into a U2.
I agree with Stuart on this. I do a lot of TIME calculations. including time zone conversions, in which the date is vital. i.e. Tuesday June 13th 1:00AM EDT is converted to Monday June 12th 10:00PM PDT. Here the date is affected as well as the time. And it *is* an ISO standard, so it would be nice if it was supported. Yeah yeah, I wrote a function. =) Don Verhagen > > Cheers, > Stuart > ______________________________________________________________________ > > Stuart > > Speaking of ICONV, anyone noticed that `DWx' > > conversions are fubar. > Sorry to sound negative and apologies if I'm misunderstanding your > gripe > but.. > How can you ICONV with a DW? Date conversions should ICONV to a > specific > date to be meaningful: if you want to convert a Monday - which Monday? > This > Monday, last Monday, nearest Monday, the first Monday (this year), > first > Monday ever? (give or take a couple of billion years). > And if IBM did pluck one of those out of a hat, you can bet your > bottom > dollar half the people on the list would complain that it wasn't > *their* > interpretation. > Some conversions just ain't meant to be reversible. > > This, along with my other gripe of not easily handling > > ISO standard > > dates (yyyy-mm-ddTHH:mm:ssZ) it seems like an > That really stems from the fact that MVDBMS sensibly separate date and > time: > something I so often wish other languages did! You can get the date > format > using: > D-YMD[4,2,2] > Eg. > LIST BOOK_SALES SALE_DATE CONV "D-YMD[4,2,2]" > LIST BOOK_SALES SALE_DATE SALE_DATE CONV "D-YMD[4,2,2]" 09:26:16am 13 > Jun > 2006 > PAGE 1 > BOOK_SALES... Sale Date.. Sale Date.. > 13660*37800*1 25 MAY 2005 2005-05-25 > 13512*63000*1 28 DEC 2004 2004-12-28 > 13715*54000*3 19 JUL 2005 2005-07-19 > Brian > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > > ********************************************************************** > > This email message and any files transmitted with it are confidential > and intended solely for the use of addressed recipient(s). If you have > received this email in error please notify the Spotless IS Support > Centre (+61 3 9269 7555) immediately, who will advise further action. > This footnote also confirms that this email message has been scanned > for the presence of computer related viruses. > > ********************************************************************** > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
