Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Location
    Cypruss
    Posts
    1

    Unanswered: Default Date Format in SybaseASE12.5 Server Wide

    Hi

    I am from the Oracle world. In oracle we can set the default date format say a "YYYYMMDD:HH24.MI.SS" or "DD-MON-YYYY.HH.MI.AM" by using nls date format SYSTEM wide, so that any user who connects to Oracle gets the same default date format.

    Do we have any such things in Sybase ASE12.5 so that once set, any user who connects to the Server get the default date format say in a query like "select getdate()"?.

    I know we can use "convert" to get the date format that we want, but the application team doesn't want that solution. They want to set some given "default date format" Server wide.

    Any Ideas please ?.

    Regards
    Kalia

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    Check
    Code:
    set dateformat

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •