Select records after specific date in SQL

Question

I have a column in my database called "begin_date". I am trying to select records where the begin_date are greater than a specific date. I put

select * from Table_Name
where begin_date >= '1/1/2014'

However, it returns error message "String to date conversion error". I am not sure how to modify the query to make it work? Thanks!

try changing the date format `..begin_date >= '2014-01-01'` – Pரதீப் Dec 28 '15 at 16:38 — Pரதீப், Dec 28 '15 at 16:38
Yay, it worked. Thanks a lot! – mumu.W Dec 28 '15 at 17:21 — mumu.W, Dec 28 '15 at 17:21

score 2 · Answer 1 · answered Dec 28 '15 at 16:38

2

Try using ISO (8601) standard date formats:

select *
from Table_Name
where begin_date >= '2014-01-01';

answered Dec 28 '15 at 16:38

Gordon Linoff

score 0 · Answer 2 · edited Dec 28 '15 at 21:11

0

select * 
from table
where data >= '01/01/2014'

edited Dec 28 '15 at 21:11

Anders

answered Dec 28 '15 at 17:06

shobhit

2 Answers2