var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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
perhaps that is what you need:
select * from sys.all_objects
where to_date(timestamp, 'yyyy-mm-dd hh24:mi:ss') = date_field
convert both to character via TO_CHAR.
But you lose the index when you do it in this way ...
Hope this helps ...