kdschool
asked on
Help with SQL Syntax for date and date range
SQL Syntax to convert this date format 26-APR-17 to yyyy-mm-dd and then select only the records between Jan 1 2017 and Jan 1 2018. The field is this in the view EVENT_DT DATE
What database?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Worked perfectly.
Glad to help.
In the future, you should add the Topic Area for the database you need the answer for. SQL is different between most of them.
In the future, you should add the Topic Area for the database you need the answer for. SQL is different between most of them.