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 [email protected] To unsubscribe please visit http://listserver.u2ug.org/
