Quick SQL Solution

Dokončeno Zveřejněno před 5 lety K zaplacení v momentě doručení
Dokončeno K zaplacení v momentě doručení

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

Identifikační číslo projektu: #18965229

O projektu

6 nabídek Projekt na dálku Aktivní před 5 lety

Uděleno uživateli:

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 Další

$20 USD za 1 den
(4 recenzí)
3.2

6 Freelnceři na tento projekt zveřejňují nabídky v průměru $26

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 Další

$30 USD za 1 den
(7 Recenzí)
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 za 0 dní
(5 Recenzí)
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 Další

$25 USD za 1 den
(0 Recenzí)
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 za 1 den
(0 Recenzí)
0.0