|Oracle Dates, Timestamps and Intervals - An overview of the usage of dates, timestamps and intervals in Oracle databases.|
Timestamp to Date said...Hello Tim,
I was looking for an option to convert timestamp data type to date. As my search lead me to your article may I suggest to add the following to it?
How to transfer timetamp to date format example:
select CAST(systimestamp AS DATE) cSYSDATE from dual;
Thanks for spotting the omission. I've added a two-way conversion into the article.
DO NOT ask technical questions here, that's what my forum is for!
These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!