Re: DBDATE / DBMONEY in SQL ���ndern ??

>From: Carsten Haese <carsten@uniqsys.com> >On Tue, 2007-07-10 at 09:39 +0000, hoffiman@googlemail.com wrote: > [Bitte, Ich spreche nicht Deutsches.] >In English: > >I'm not aware of a way to set the date format with an SQL command. One >possibility would be to load the data into an auxiliary table that is >identical to the target table except that date columns are replaced by >char(10) columns. You can then transfer the data to the target table and >translate the date columns with mdy(x[6,7],x[9,10],x[1,4]) into real >dates. > >Hope this helps, > >-- This doesn't make sense. The date is stored in an intermediate format and should be formattable via regex from the SQL statement. (Sorry my mind is a bit garbled from doing too many different database things as well as languages.) There should be an SQL function that would allow you to format the date from the internal format to a more readable string on the fly. If there isn't, there should be. ;-) I would think that it would be a trivial UDF with 2 parameters. The date and the regex returning a string. But what do I know? I *believed* IBM would have their RoR for IDS available for a public beta back a month ago. :-( -G _________________________________________________________________ http://im.live.com/messenger/im/home/?source=hmtextlinkjuly07