Thread: sql
-
hi can someone give me a hint,
i want to get the data from yeaterday 2 pm to today 3 pm.
thanks
Nallamothu
-
How about a hint of what columns are in the table to query against.
Gary
-
SELECT *
FROM my_table
WHERE my_date_column BETWEEN (trunc(sysdate-1)+14/24) AND (trunc(sysdate)+15/24);
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|