If you’re using moment.js you can simply call… moment.duration(‘PT15M33S’).asMilliseconds(); = 933000 ms EDIT 2021: While this works, and still gets upvotes, I wouldn’t advise including moment.js just for this. I’d recommend using a regex answer like @redgetan’s
tl;dr Use the modern java.time classes instead of those troublesome legacy date-time classes. myPreparedStatement.setObject( … , Instant.now() // Capture the current moment in UTC. ) Old Date-Time Classes Poorly Designed Put more bluntly, the java.sql.Timestamp/.Date/.Time classes are a hack, a bad hack. Like java.util.Date/.Calendar, they are the result of poor design choices. The java.sql types … Read more
You are setting the time in milliseconds, but your input precision is in microseconds, so of course you are going to lose any precision finer than milliseconds. Calendar doesn’t support finer granularity than milliseconds. There is no work-around.
The problem is that your field is defined as TIMESTAMP but UNIX_TIMESTAMP returns an int. Use INSERT INTO test VALUES (‘2013-08-05 18:19:03’ ) instead.
You might be able to use DateTime after all. DateTime.Ticks‘ resolution is 100 nanoseconds. You can set the ticks with DateTime.AddTicks.
For ext2/3 and possibly for ext4 you can do this with debugfs tool, assuming you want to change the ctime of file /tmp/foo which resides in disk /dev/sda1 we want to set ctime to 201001010101 which means 01 January 2010, time 01:01: Warning: Disk must be unmounted before this operation # Update ctime debugfs -w … Read more
All the solutions above are hefty, pure JS, vanilla solutions. If you’re okay to use a couple of libraries, then lodash and moment can be used together for a simple one liner: ES6 let groupedResults = _.groupBy(results, (result) => moment(result[‘Date’], ‘DD/MM/YYYY’).startOf(‘isoWeek’)); Older JS var groupedResults = _.groupBy(results, function (result) { return moment(result[‘Date’], ‘DD/MM/YYYY’).startOf(‘isoWeek’); }); This … Read more
Via code You can configure the TraceOutputOptions flags enum. var listener = new ConsoleTraceListener() { TraceOutputOptions = TraceOptions.Timestamp | TraceOptions.Callstack }; Trace.Listeners.Add(listener); Trace.TraceInformation(“hello world”); This does not work for Write and WriteLine, you have use the TraceXXX methods. Via app.config This can also be configured in your App.config with a somewhat equivalent and using TraceSource: … Read more
The manual states the values as: Low value: 4713 BC High value: 294276 AD with the caveat, as Chris noted, that -infinity is also supported. See the note later in the same page in the manual; the above is only true if you are using integer timestamps, which are the default in all vaguely recent … Read more