I have a query that converts URL variables called myDate to a datetime.
select CONVERT(datetime,(#URL.mydate#-2)) AS DATE
So when myDate = 43531, the datetime that is generated is 2019-03-07 00:00:00.0.
I need a new sql query that takes a datetime like 2019-03-07 00:00:00.0 and gets back 43531.
So essentially the reverse of what I have in the query above.
I need this within 1 hour. Thanks!
7 freelancere byder i gennemsnit $27 på dette job
Hi, I am 8 years experienced web developer expert in MySql. I understand your point. I can complete this project within one hour . Please check my profile for my work quality . Thanks, Bhaskar Mandal