04/07/2012

[SQL] String to Date

In SQL, you can create a Date value from a String representation with:

TO_DATE('string_date', 'pattern');

Where string_date is the String representation of the date you are working on, like '31/12/1900' and pattern defines how your date is represented, as 'dd/mm/yyyy' in our example.

You can also test two Date values using  the < = > ! operators.

No comments:

Post a Comment

With great power comes great responsibility