Results 1 to 2 of 2

Thread: datetime format

  1. #1
    Join Date
    Jun 2006

    Unanswered: datetime format

    now, I also have a question :
    We are using db2 udb on windows and stored proc in sql language.
    we can (in V8) call set_routine_opts to force a specific datetime setting at build of stored proc.
    Is there any possibility, by mean of programming, to change the dateformat while executing the stored proc or do we have to use a function as to_date(.. ?
    Anyone any hint for this ?
    Best Regards, Guy Przytula
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  2. #2
    Join Date
    Aug 2001
    The datetime format is a 'property' of the associated package. So I very much doubt if this property can be changed at bind time ...

    How you hadle will depend on the requirement .... See if the date time formats supported in CHAR and TO_CHAR functions is of any help

    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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