date-conversion – Tarik Billa

How to convert LocalDateTime to OffsetDateTime?

December 25, 2023 by Tarik

There are many ways to convert LocalDateTime to OffsetDateTime. Some of them are listed below: 1. Using LocalDateTime#atOffset(ZoneOffset offset): LocalDateTime ldt = LocalDateTime.now(); ZoneOffset offset = ZoneOffset.UTC; OffsetDateTime odt = ldt.atOffset(offset); 2. Using LocalDateTime#atZone(ZoneId zone) => ZonedDateTime#toOffsetDateTime(): LocalDateTime ldt = LocalDateTime.now(); // Change the ZoneId as required e.g. ZoneId.of(“Europe/London”) ZoneId zoneId = ZoneId.systemDefault(); OffsetDateTime odt … Read more

How convert Gregorian date to Persian date?

March 23, 2023 by Tarik

Use the PersianCalendar: string GregorianDate = “Thursday, October 24, 2013”; DateTime d = DateTime.Parse(GregorianDate); PersianCalendar pc = new PersianCalendar(); Console.WriteLine(string.Format(“{0}/{1}/{2}”, pc.GetYear(d), pc.GetMonth(d), pc.GetDayOfMonth(d)));

Converting unix time into date-time via excel

February 11, 2023 by Tarik

To convert the epoch(Unix-Time) to regular time like for the below timestamp Ex: 1517577336206 First convert the value with the following function like below =LEFT(A1,10) & “.” & RIGHT(A1,3) The output will be like below Ex: 1517577336.206 Now Add the formula like below =(((B1/60)/60)/24)+DATE(1970,1,1) Now format the cell like below or required format(Custom format) m/d/yyyy … Read more

How to remove the time portion of a datetime value (SQL Server)?

January 28, 2023 by Tarik

SQL Server 2008 and up In SQL Server 2008 and up, of course the fastest way is Convert(date, @date). This can be cast back to a datetime or datetime2 if necessary. What Is Really Best In SQL Server 2005 and Older? I’ve seen inconsistent claims about what’s fastest for truncating the time from a date … Read more

How to convert a string Date to long millseconds

January 9, 2023 by Tarik

Using SimpleDateFormat String string_date = “12-December-2012”; SimpleDateFormat f = new SimpleDateFormat(“dd-MMM-yyyy”); try { Date d = f.parse(string_date); long milliseconds = d.getTime(); } catch (ParseException e) { e.printStackTrace(); }

Go time.Now().UnixNano() convert to milliseconds?

December 16, 2022 by Tarik

The 2021 answer: As of go v1.17, the time package added UnixMicro() and UnixMilli(), so the correct answer would be: time.Now().UnixMilli() Original answer: Just divide it: func makeTimestamp() int64 { return time.Now().UnixNano() / int64(time.Millisecond) } Here is an example that you can compile and run to see the output package main import ( “time” “fmt” … Read more

How to get the integer value of day of week

December 12, 2022 by Tarik

Use day1 = (int)ClockInfoFromSystem.DayOfWeek;

Convert one date format into another in PHP

September 24, 2022 by Tarik

The second parameter to date() needs to be a proper timestamp (seconds since January 1, 1970). You are passing a string, which date() can’t recognize. You can use strtotime() to convert a date string into a timestamp. However, even strtotime() doesn’t recognize the y-m-d-h-i-s format. PHP 5.3 and up Use DateTime::createFromFormat. It allows you to … Read more