|
-
This is bcoz the date type and char type is not the same thing.
When we insert date into the table, it is not only that date being inserted, the time is inserted as well. So, U need use the conversion function "to_char" against the date column to make a query based on Ur specific condition, somthing like:
" where to_char(data_col) = 'specific date' " in the query. Sure, there are other ways, but they are generally based on the date features.
Take care
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
|