Sybase alter session DATEFORMAT ???

[Autosys]

Hi there,

Can sombody please tell me how to format the Date for a patricular session in Sybase? I know in Oracle you can do a: alter session set nls_date_format = 'YYYY-MM-DD HH24:MI:SS'

All the examples I've so far seen for Sybase only show: 'alter session set DATEFORMAT ymd' How do you add the hours, minutes and seconds then?

Sorry if this is a stupid question but I'm having a moment.

Your help will be greatly appreciated.
S

 

[DotNetGnat]

you can use CONVERT() function i guess...

-DNG

 

[Autosys]

Cheers DNG - You're right I can use the convert function for queries but would like to somhow alter the session once. Perhaps the convert function can still do that, I'll investigate.

 

[DotNetGnat]

no problem...glad to be of help...

-DNG

 

[dbalearner]

Also try set dateformat for the session just like Oracle

1> set dateformat ymd
2> go

 

[Autosys]

Have done that thanks mate! I'm just confused as to why you can't add the hh,mi,ss to that last statement of yours.