Strictly, method a is the least resource intensive: a) select DATEADD(dd, DATEDIFF(dd, 0, getdate()), 0) Proven less CPU intensive for the same total duration a million rows by someone with way too much time on their hands: Most efficient way in SQL Server to get a date from date+time? I saw a similar test elsewhere … Read more
Short answer: Date in = new Date(); LocalDateTime ldt = LocalDateTime.ofInstant(in.toInstant(), ZoneId.systemDefault()); Date out = Date.from(ldt.atZone(ZoneId.systemDefault()).toInstant()); Explanation: (based on this question about LocalDate) Despite its name, java.util.Date represents an instant on the time-line, not a “date”. The actual data stored within the object is a long count of milliseconds since 1970-01-01T00:00Z (midnight at the start … Read more
Use the Date property: var dateAndTime = DateTime.Now; var date = dateAndTime.Date; The date variable will contain the date, the time part will be 00:00:00.
See Windows Batch File (.bat) to get current date in MMDDYYYY format: @echo off For /f “tokens=2-4 delims=/ ” %%a in (‘date /t’) do (set mydate=%%c-%%a-%%b) For /f “tokens=1-2 delims=/:” %%a in (‘time /t’) do (set mytime=%%a%%b) echo %mydate%_%mytime% If you prefer the time in 24 hour/military format, you can replace the second FOR line … Read more
You can use datetime.timedelta function: >>> import datetime >>> str(datetime.timedelta(seconds=666)) ‘0:11:06’
If you have two date objects, you can just subtract them, which computes a timedelta object. from datetime import date d0 = date(2008, 8, 18) d1 = date(2008, 9, 26) delta = d1 – d0 print(delta.days) The relevant section of the docs: https://docs.python.org/library/datetime.html. See this answer for another example.
Since you are handling 24-hour based time and you have a comma separating the seconds fraction, I recommend that you specify a custom format: DateTime myDate = DateTime.ParseExact(“2009-05-08 14:40:52,531”, “yyyy-MM-dd HH:mm:ss,fff”, System.Globalization.CultureInfo.InvariantCulture);
In general, to make a naive datetime timezone-aware, use the localize method: import datetime import pytz unaware = datetime.datetime(2011, 8, 15, 8, 15, 12, 0) aware = datetime.datetime(2011, 8, 15, 8, 15, 12, 0, pytz.UTC) now_aware = pytz.utc.localize(unaware) assert aware == now_aware For the UTC timezone, it is not really necessary to use localize since … Read more
Using time.time(): import time def current_milli_time(): return round(time.time() * 1000) Then: >>> current_milli_time() 1378761833768
DateTime.Now.ToString(“yyyyMMddHHmmss”); // case sensitive