Top "Datetime-conversion" questions

Use this tag for questions related to the Datetime conversion, i.e. manipulating the Datetime in such a way, that a new, different in format, Datetime is produced.

Compare DATETIME and DATE ignoring time portion

I have two tables where column [date] is type of DATETIME2(0). I have to compare two records only by theirs …

sql sql-server tsql sql-server-2008 datetime-conversion
How to check if DST (Daylight Saving Time) is in effect, and if so, the offset?

This is a bit of my JS code for which this is needed: var secDiff = Math.abs(Math.round((utc_…

javascript datetime dst timezone-offset datetime-conversion
Convert from days to milliseconds

I want to create a function that will convert the days into milliseconds. The days format is stored as 0.2444, so …

java datetime-conversion
How to convert ZonedDateTime to Date?

I am trying to set a server agnostic date time in my database and I believe the best practice to …

java java-8 java.util.date datetime-conversion zoneddatetime
Convert DateTime for MySQL using C#

I want to change the DateTime for MySQL in C#. My MySQL database only accept this format 1976-04-09 22:10:00. In …

c# .net mysql datetime datetime-conversion
How to convert a 24 hour time to 12 hour in VB.net as hh:mm AM/PM

So let's say I have 1400, I want to convert it into 2:00PM I tried the following: Dim convertedTime As String = …

vb.net time string-formatting datetime-conversion
pandas convert from datetime to integer timestamp

Considering a pandas dataframe in python having a column named time of type integer, I can convert it to a …

python pandas timestamp datetime-conversion
How to convert from UTC to local time in C?

It's a simple question, but the solution appears to be far from simple. I would like to know how to …

c time posix utc datetime-conversion
Convert ZonedDateTime to LocalDateTime at time zone

I have an object of ZonedDateTime that is constructed like this ZonedDateTime z = ZonedDateTime.of(LocalDate.now().atTime(11, 30), ZoneOffset.UTC); …

java java-8 timezone datetime-conversion zoneddatetime
LocalDateTime to java.sql.Date in java 8?

How to convert LocalDateTime to java.sql.Date in java-8? My search on internet mostly give me Timestamp related code …

java-8 java-time datetime-conversion