Oracle data type transform to to_char in sql

16 Oct

If you want to get the whole date and time format from e.g sysdate you can run the following query in sql:

select to_char(sysdate,’YYYY-MM-DD:HH24:MI:SS’) from dual

 

http://stackoverflow.com/questions/15833030/oracle-date-datatype-transformed-to-yyyy-mm-dd-hh24miss-tmz-through-sql

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: