BODS DATE FORMAT

dataservices job design
1

Hi,

How to produce a date format of the type as given in the following example. The BODS global variable should display the following format…
eg. 2012-04-19-11.02.41.020000

Thanks

rajnia1 (BOB member since 2011-11-17)

2

to_char(sysdate(), ‘YYYY-MM-DD-HH24.MI.SS.NNNNNN’)

should do the trick

Werner Daehn :de: (BOB member since 2004-12-17)

3

it doesn’t work… :smiley:

amitkg87 (BOB member since 2017-07-24)