EDIT: Okay, so you don’t want your local time (which isn’t Australia) to contribute to the result, but instead the Australian time zone. Your existing code should be absolutely fine then, although Sydney is currently UTC+11, not UTC+10.. Short but complete test app: import java.util.*; import java.text.*; public class Test { public static void main(String[] … Read more
You can obtain months’ names in two cases, Nominative: DateTimeFormatInfo info = CultureInfo.GetCultureInfo(“ru-RU”).DateTimeFormat; // February: 2 – 1 (array is zero based) – “Февраль” Console.Write(info.MonthNames[2 – 1]); And Genitive: // February: 2 – 1 (array is zero based) – “февраля” Console.Write(info.MonthGenitiveNames[2 – 1]); Other cases (e.g. Dative, Accusative) are not supported and we have to … Read more
I think your date format does not make sense. There is no 13:00 PM. Remove the “aaa” at the end of your format or turn the HH into hh. Nevertheless, this works fine for me: String testDate = “29-Apr-2010,13:00:14 PM”; DateFormat formatter = new SimpleDateFormat(“d-MMM-yyyy,HH:mm:ss aaa”); Date date = formatter.parse(testDate); System.out.println(date); It prints “Thu Apr … Read more
Edit: I should add that these are nanoseconds not milliseconds. I feel these answers don’t really answer the question using the Java 8 SE Date and Time API as intended. I believe the truncatedTo method is the solution here. LocalDateTime now = LocalDateTime.now(); System.out.println(“Pre-Truncate: ” + now); DateTimeFormatter dtf = DateTimeFormatter.ISO_DATE_TIME; System.out.println(“Post-Truncate: ” + now.truncatedTo(ChronoUnit.SECONDS).format(dtf)); … Read more
Here is an example of getting the future date… var targetDate = new Date(); targetDate.setDate(targetDate.getDate() + 10); // So you can see the date we have created alert(targetDate); var dd = targetDate.getDate(); var mm = targetDate.getMonth() + 1; // 0 is January, so we must add 1 var yyyy = targetDate.getFullYear(); var dateString = dd … Read more
Since SQL Server Version 2012 you can use: SELECT format(getdate(),’yyyyMMddHHmmssffff’)
It’s just another way of writing yyyyMMdd. The CC part represents the century, while YY is the two-digit year.
Given the output you’re stuck with, I can’t think of any better way to catch a DateTime of 0 on the javascript side. Date.parse should work for your parsing needs, but it returns number of milliseconds, so you need to wrap a Date constructor around it: var date = new Date(Date.parse(myCSharpString)); For the return date, … Read more
It’s been asked on the mailing list and the answer is that it is not possible because the original pattern is not retained. The same thread suggests using a DateTimeFormatterBuilder which does have the information.