SQL – query on date

Jan15
  • Share

Difficulty: ★☆☆☆☆

Say you want to query all the fields after a specific date.
You’ll just write a sql with a value > then the filled in date.
But how do you specify a date? You need the to_Date function for doing this.

TIMESTAMP >= to_Date('20081203','yyyymmdd')


Leave a comment