MySQL Conversion to DATE Type

Ask Question

Asked 11 years, 8 months ago

Modified 11 years, 8 months ago

Viewed 57 times

What is the difference between the return values for these two expressions in MySQL:

date('2011-01-01')

cast('2011-01-01' AS DATE)

asked Apr 6, 2012 at 0:16

AJ.

1351 silver badge7 bronze badges

Add a comment |

1 Answer 1

Sorted by:

There is no difference between the two, you get a date field in both instances

answered Apr 6, 2012 at 8:35

1,92714 silver badges12 bronze badges

Add a comment |

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.