CONVERT TIMESTAMP IN Query

[nread]

Hi

Does anyone know how i can select a substr() of a timestamp field...?

The data within the field is stored as
12-JUL-04 10.00.36.000000 AM and i need to pull out certain records within a particular time period.

Thanks for any help provided.

N

 

[lewisp]

The data is the field is not stored in that format, it is simply displayed in that format as defined by your DBAs.

You can select records [tt]WHERE To_Char(Date_column,'HH24:MI:SS') BETWEEN '12:00:00' AND '13:00:00'[/tt] for example.