Sybase Date format

[Courtney]

Can anybody tell me how to set the date format in sybase or should I say is
there a configuration in sybase that set the default date format ? If so how
can I view the settings or change it. From what I know (which might be very
little) Sybase takes the date format from the OS.

I am running sybase 11.5.1 on solaris 2.6

Thanks

[Dilip_Wadhwa]

Hello,

Alter the dateformat in the $SYBASE/locales/english/common.loc file.
Execute sp_addlanguage for us_english specifying the required date format,
and bounce the server.
Changing the common.loc file fixes the date conversions on the client side;
the sp_addlanguage fixes the date conversions on the server side

HIH,
Regds..Dilip

[Dilip_Wadhwa]

Hello,

For a session level 'set dateformat' sets the order of the date parts
month/day/year for entering datetime or smalldatetime data. Valid arguments
are mdy, dmy, ymd, ydm, myd, and dym.

set dateformat dmy
go

[Courtney]

Thanks Dilip.

--

<Dilip_Wadhwa> wrote in message
news:C3EFBE603A6B8881007791D985256A95.00777D0985256A95@webforums...