Click here to Skip to main content
14,389,695 members
Rate this:
Please Sign up or sign in to vote.
See more:
i use a query in MS Sql Server
dateadd<=convert(varchar,getdate(),111)

how to use this in MySql query
Posted

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

use
dateadd<=DATE_FORMAT(CURDATE(), '%Y%m%d')
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100