Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Location
    Nottingham - UK
    Posts
    113

    Unhappy Unanswered: Timestamp query - Newbie

    I am trying to query a timestamp field by date, can anyone help with some sample script pls.

    Thanks in advance

  2. #2
    Join Date
    Jul 2001
    Location
    Germany
    Posts
    189
    Hello,

    perhaps that is what you need:

    select * from sys.all_objects
    where to_date(timestamp, 'yyyy-mm-dd hh24:mi:ss') = date_field

    or

    convert both to character via TO_CHAR.

    But you lose the index when you do it in this way ...
    Hope this helps ...

    Greetings
    Manfred Peter
    (Alligator Company)
    http://www.alligatorsql.com

Posting Permissions

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