[Resolved] determining timestamp value in MySQL

[perpetualshaun]

Is there something I can add to my sql query to see if the data in a field is a timestamp? I'd like to have a statement something like this:

SELECT order_number FROM orders WHERE (is_numeric(ship_date) OR ship_date='0000-00-00') ORDER BY order_number

I know that I can't use the is_numeric in the query, but is there something comparable that I can add to my query here.

Thanx,

Shaun

[LordShryku]

That's what field types are for...
What kind of field are you trying this in?

[perpetualshaun]

it's actually a VARCHAR field type. I want them to be enter freeform text when checking out, but then the value in that field is updated w/ the appropriate timestamp when the order is shipped.

[LordShryku]

If it's a varchar field, it will never be interpreted a numeric unless you cast it to a numeric...