Adjust datefield in sql server to a slightly different format

$10-30 USD

Fullført

Lagt ut

over 6 år siden

$10-30 USD

Betalt ved levering

I have a datetime field in the example format 2017-11-05 09:48:57.000 2017-11-06 14:54:16.000 I need a sql server query that takes the datetime field and outputs the as the following example format 11/5/2017 9:48:00 AM 11/6/2017 2:54:16 PM notes: * this is for microsoft sql server 2014 * the output should have no leading zero's in the day field thanks.

Microsoft SQL Server

SQL

Prosjekt-ID: 15577491

Om prosjektet

3 forslag

Eksternt prosjekt

Aktiv 7 år siden

Ønsker du å tjene penger?

E-postadresse

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen

Få betalt for arbeidet ditt

Skisser forslaget ditt

Det er gratis å registrere seg og by på jobber

Tildelt til:

@stillart

Hello, if you award me the project now I will complete it in one hour. Best Stay tuned, I'm still working on this proposal.

$20 USD om 1 dag

5,0

(2 omtaler)

1,5

3 frilansere byr i gjennomsnitt $27 USD for denne jobben

@Meagan26

Hello, I have read through your project and I am incredibly interested in taking on your project. I am an experienced developer with a diploma in the field of web development. Relevant Skills and Experience sql expert i can complete this for u quickly or as soon as you need it complete Proposed Milestones $35 USD - completion

$35 USD om 1 dag