SQL Sorting by date column stored as a string

Right so you have a column in Oracle table thats stores a date field – trouble is that its stored as a CHAR.  How can I Sort it then ?

This is how….

COLUMN metadataname FORMAT A16;

COLUMN metadatavalue FORMAT A20;

select metadataname, metadatavalue fromectd_prod_3x.ectd_metadata where metadataname = ‘Submission Date’ order by to_date(metadatavalue,’dd/mm/yyyy’);

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