Quick SQL Solution

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!

Taidot: Microsoft SQL Server, SQL

Näytä lisää: sql assignments with solutions, sql exercises pdf, oracle sql practice exercises with solutions pdf, oracle sql practice exercises with solutions, rapid sql tutorial, w3resource sql exercises, sql server forms builder, rapid sql wiki, rss sql php hour, quick books sql, crystal reports sql server consult per hour, sql server 2000 quick table count, exercise solution sql server, solution sql server 2005, sql server network quick, sql server tutoring phone hour, look free translation english arabic quick easily thanks, home work sql solution, sql solution, sport league sql solution

Tietoa työnantajasta:
( 104 arvostelua ) Mount Savage, United States

Projektin tunnus: #18965229

Myönnetty käyttäjälle:


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 Lisää

$20 USD 1 päivässä
(1 arvostelu)

7 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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 0 päivässä
(5 arvostelua)

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 Lisää

$30 USD 1 päivässä
(6 arvostelua)

sql server expert do it now with in 1 hr before • SQL Server 2005,2008,2012,2014,2017 •,3.5,4.0,4.5,4.5.1), Web Service, Xml, Ajax and Object-Oriented Programming, Good Knowledge On [login to view URL], Sql, Linq • Lisää

$25 USD 1 päivässä
(2 arvostelua)

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 Lisää

$25 USD 1 päivässä
(0 arvostelua)

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 1 päivässä
(0 arvostelua)

I am a senior SQL Server Developer/DBA and will be more than happy to start working on it today. Let me know should you have any more questions in regards to what needs to be achieved and such. I can sort it out im Lisää

$35 USD 1 päivässä
(0 arvostelua)