Incorrect time entry in datetime sql server format

Question

Hi the query below performs an insert on sql server, when the insert is done date minutes and seconds are correct but the time is wrong (if there are 8 and I insert an insert the value is saved 7) the format of the hours is that Italian, below the sql code that executes the insert. How do I solve this?

Sql Server:

Insert into Magazzino(Nome,Indirizzo,DataCreazione) 
values(@Nome,@Indirizzo,convert(datetime, GETDATE(),105))

What is the type of `DataCreazione` column? This sounds like a representation issue. `datetime` itself does not have any format. — Soner Gönül, Feb 14 '19 at 07:11
Have you got the right Time Region? At the command line do a `tzutil /g` — Jeremy Thompson, Feb 14 '19 at 07:12
What is the point of converting the date to insert it into the database? — BytesOfMetal, Feb 14 '19 at 07:12
@riki Huh? Is `GETDATE()` actually a Italian date string you're inserting? — ProgrammingLlama, Feb 14 '19 at 07:13
105 format is "dd-mm-yyyy". You can store without converting it and convert it while displaying on UI. No meaning of converting it while storing. — Gaurang Dave, Feb 14 '19 at 07:15
`datetime2` (and it's related similar types) don't **have** a format. They're a count of the number of intervals that have occurred since some epoch date. Leave **formatting** to your presentation layer - not the database. — Damien_The_Unbeliever, Feb 14 '19 at 07:27
@GaurangDave - the *style* parameter to convert is going to be ignored. `GETDATE()` returns a `datetime`. The `CONVERT` call is being asked to convert its input to a `datetime`. That's a no-op - it just returns its input. — Damien_The_Unbeliever, Feb 14 '19 at 07:31

Code Maverick · Accepted Answer · 2019-02-14T09:17:36.293

1

Documentation states that GETDATE() stores the date and time of the computer on which the instance of SQL server is running. To resolve this, you have two options:

Update configuration of SQL server instance. See this - this may require Operations/MIS support.
Use datetimeoffset on GetUTCDate(). See this.

P.S.: Kindly change the tag of this question to t-sql or sql-server!

edited Feb 14 '19 at 09:17

answered Feb 14 '19 at 07:21

Code Maverick

326
2
6

Incorrect time entry in datetime sql server format

1 Answers1