Quick SQL Solution

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

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!

Microsoft SQL Server SQL

Project ID: #18965229

About the project

6 proposals Remote project Active 5 years ago

Awarded to:

Andrei901120

Dear sir. I can give an answer within a few minutes. I served as a DBA for a few years and I have enough experience on DBMS such as Oracle, MySQL and PostgreSQL. I am the developer who you are looking for now. Plea More

$20 USD in 1 day
(4 Reviews)
3.2

6 freelancers are bidding on average $26 for this job

kipdev13

Hi, Dear! I`m great interested in your suggest. I`m a good In sql. If you're interested - contact me. Let's get in touch to discuss your project in more detail via here. It would be great to More

$30 USD in 1 day
(7 Reviews)
4.0
bhaskarmandal

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

$30 USD in 0 days
(5 Reviews)
3.8
osrootofos

An Oracle DBA / Apps DBA with 8+ years of experience on Windows / Unix platforms. I have strong DBA skill and have worked on multiple Oracle Technologies. I have experience on production support, upgrades, platform m More

$25 USD in 1 day
(0 Reviews)
0.0
suatyuksel1

i can do it very quickly if it is urgent for you . Thank you for taking me time . Süleyman Suat Yüksel

$25 USD in 1 day
(0 Reviews)
0.0