date runction

[nagama]

Hi.,

Can somebody help to get the date in the following format.

dd-mon-yy (i.e, 01-May-05).

Thanks for your help.

 

[dnoeth]

select current_date (format 'yyyy-mmm-dd');

*** Query completed. One row found. One column returned.
*** Total elapsed time was 1 second.

Date
-----------
2006-Jul-08

Dieter

 

[BillDHS]

Unless something has change, ODBC does not accept format statements. If you are using ODBC connectivity you will also need to CAST the date to maintain the format:

select CAST(current_date (format'yyyy-mmm-dd')as char(11));