Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    7

    Unanswered: URGENT HELP reg query

    Guys,
    START_DATE is a field in a table.I need to retreive (START_DATE - 1 day) from a table.START_DATE is Timestamp datatype.
    How to write this query.
    Thanks,
    Shiva.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    I am not sure exactly what you want. At face value, you are asking for:

    SELECT START_DATE - 1 DAY as new_TIMESTAMP from MyTable

    HTH

    Andy

Posting Permissions

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