An in-depth explanation of oracle datetime timestamp, oracletimestamp

An in-depth explanation of oracle datetime timestamp, oracletimestamp

1. Convert string type to timestamp

Select to_timestamp ('01-October-08 07.46.41.000000000 AM ', 'dd-MON-yy hh: mi: ss. ff am') from dual;

2. Convert timestamp to date type

Select cast (to_timestamp ('01-October-08 07.46.41.000000000 AM ', 'dd-MON-yy hh: mi: ss. ff am') as date) timestamp_to_datefrom dual;

3. Convert the date type to timestamp

Select cast (sysdate as timestamp) date_to_timestamp from dual;

4. Obtain the system time in timestamp format

Select distinct imestamp from dual;