This approach uses strptime and strftime with format directives as per https://docs.python.org/2/library/datetime.html#strftime-strptime-behavior, %H is the 24 hour clock, %I is the 12 hour clock and when using the 12 hour clock, %p qualifies if it is AM or PM. >>> from datetime import datetime >>> m2 = ‘1:35 PM’ >>> in_time = datetime.strptime(m2, “%I:%M %p”) … Read more
Keep in mind that you can hard-code ISO format string formatForMySql = dateValue.ToString(“yyyy-MM-dd HH:mm:ss”); or use next: // just to shorten the code var isoDateTimeFormat = CultureInfo.InvariantCulture.DateTimeFormat; // “1976-04-12T22:10:00” dateValue.ToString(isoDateTimeFormat.SortableDateTimePattern); // “1976-04-12 22:10:00Z” dateValue.ToString(isoDateTimeFormat.UniversalSortableDateTimePattern) and so on
You can typecast to int using astype(int) and divide it by 10**9 to get the number of seconds to the unix epoch start. import pandas as pd df = pd.DataFrame({‘time’: [pd.to_datetime(‘2019-01-15 13:25:43’)]}) df_unix_sec = pd.to_datetime(df[‘time’]).astype(int)/ 10**9 print(df_unix_sec)
How can I convert it to LocalDateTime at time zone of Switzerland? You can convert the UTC ZonedDateTime into a ZonedDateTime with the time zone of Switzerland, but maintaining the same instant in time, and then get the LocalDateTime out of that, if you need to. I’d be tempted to keep it as a ZonedDateTime … Read more
The best practice for this, in my opinion is: TimeUnit.DAYS.toMillis(1); // 1 day to milliseconds. TimeUnit.MINUTES.toMillis(23); // 23 minutes to milliseconds. TimeUnit.HOURS.toMillis(4); // 4 hours to milliseconds. TimeUnit.SECONDS.toMillis(96); // 96 seconds to milliseconds.
You can convert ZonedDateTime to an instant, which you can use directly with Date. Date.from(java.time.ZonedDateTime.now().toInstant());
Use the CAST to the new DATE data type in SQL Server 2008 to compare just the date portion: IF CAST(DateField1 AS DATE) = CAST(DateField2 AS DATE)
This code uses the fact that getTimezoneOffset returns a greater value during Standard Time versus Daylight Saving Time (DST). Thus it determines the expected output during Standard Time, and it compares whether the output of the given date the same (Standard) or less (DST). Note that getTimezoneOffset returns positive numbers of minutes for zones west … Read more