Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2004
    Posts
    12

    Unanswered: date manipulation

    Hi all,
    I have following issue - a column DATUM (type DATE) value needs to be updated in this way, use date and set time to 11:59 AM

    Example:
    before
    DATUM
    -----------------------
    10.12.2001 10:23:10 AM
    14.01.2003 05:40:42 PM

    after
    DATUM
    -----------------------
    10.12.2001 11:59:00 PM
    14.01.2003 11:59:00 PM

    running set date by to_char,'DD.MM.YY HH24:MI')||' 23:59' gives error 1830.

    Any ideas?

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    TRUNC(datum)+1439/1440 will do it.

    (1440 minutes in a day).

  3. #3
    Join Date
    Aug 2004
    Posts
    12
    Many thanks - it's working fine

Posting Permissions

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