Oracle SQL timestamps in where clause

Question

I need to look up rows within a particular time frame   select    from TableA  where startdate  gt    12-01-2012 21 24 00     and startdate  lt    12-01-2012 21 25 33    I e   I need to look up rows with timestamp precision of SECONDS  How do I achieve this   FYI  The startdate column is of type TIMESTAMP

User · Answer

For everyone coming to this thread with fractional seconds in your timestamp use   to timestamp  2018-11-03 12 35 20 419000    YYYY-MM-DD HH24 MI SS FF

User · Answer

to timestamp    You need to use to timestamp   to convert your string to a proper timestamp value   to timestamp  12-01-2012 21 24 00    dd-mm-yyyy hh24 mi ss     to date    If your column is of type DATE  which also supports seconds   you need to use to date    to date  12-01-2012 21 24 00    dd-mm-yyyy hh24 mi ss     Example  To get this into a where condition use the following   select    from TableA  where startdate  gt   to timestamp  12-01-2012 21 24 00    dd-mm-yyyy hh24 mi ss     and startdate  lt   to timestamp  12-01-2012 21 25 33    dd-mm-yyyy hh24 mi ss     Note  You never need to use to timestamp   on a column that is of type timestamp

[sql] Oracle SQL : timestamps in where clause

Examples related to sql

Examples related to oracle

Examples related to where

Examples related to sql-timestamp