Al Programming
Free source code programming in C#, VB.Net, Java, SQL
Search This Blog
Tuesday, February 18, 2014
Timestamp to date Oracle
Oracle
> Timestamp >
To Date
select
*
from
your_table
where
TO_DATE
(
TO_CHAR
(
timestamp_date
,
'YYYY-MON-DD'
),
'YYYY-MON-DD'
)
=
'18-FEB-2014'
Newer Post
Older Post
Home
