Færdiggjort

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!

Evner: Microsoft SQL Server, SQL

Se mere: 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

Om arbejdsgiveren:
( 104 bedømmelser ) Mount Savage, United States

Projekt ID: #18965229

Tildelt til:

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 Flere

$20 USD på 1 dag
(1 bedømmelse)
1.1

7 freelancere byder i gennemsnit $27 på dette job

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 dage
(5 bedømmelser)
3.7
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 Flere

$30 USD på 1 dag
(6 bedømmelser)
3.2
saifansari2

sql server expert do it now with in 1 hr before • SQL Server 2005,2008,2012,2014,2017 • Asp.net(3.0,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 • Flere

$25 USD på 1 dag
(2 bedømmelser)
0.5
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 Flere

$25 USD på 1 dag
(0 bedømmelser)
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 på 1 dag
(0 bedømmelser)
0.0
yavorvrachev

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 Flere

$35 USD på 1 dag
(0 bedømmelser)
0.0