How to filter out all the entries with 0000:00:00 00:00 entries?

Asked Feb 02 '15 at 06:20

Active Feb 02 '15 at 06:55

Viewed 91 times

I have created a table with a column that has the time stamp of all the entries. and it also allows my consumers to put date. But now due to some users who enter fake dates like

**2014:08:23 00:03**
**0000:05:22 12:34**
**2013:00:12 01:32**

so now how do I eliminate all the invalid entries and display only those have the valid date.

asked Feb 02 '15 at 06:20

Jaqualine Cook

Have you tried anything? – Sougata Bose Feb 02 '15 at 06:23
What is the column type? – Burhan Khalid Feb 02 '15 at 06:24
i tried converting it into epoch and then matching but that again increased my complexity. I tried using strtotime and date() and time() also. – Jaqualine Cook Feb 02 '15 at 06:28
Whould you like to delete it from the database? Or only from the frontend visualisation? – Jens Feb 02 '15 at 06:29
@burhan..the column type is timestamp – Jaqualine Cook Feb 02 '15 at 06:29
DATE_FORMAT(date,%Y) !='0000' use in your selecting query – Anand Somasekhar Feb 02 '15 at 06:32
@Jens its only for the front end visualization. – Jaqualine Cook Feb 02 '15 at 06:34
@anand what if the date comes like 2014:00:23. the year according to you will be valid. but the date is actually invalid. – Jaqualine Cook Feb 02 '15 at 06:36
two options are there, check year, month, date separately in your query or add date time calender at front end – Anand Somasekhar Feb 02 '15 at 06:41

How to filter out all the entries with 0000:00:00 00:00 entries?

0 Answers0