to_date converts the input to a DATE type which does not support fractional seconds. To use fractional seconds you need to use a TIMESTAMP type which is created when using to_timestamp pst’s comment about the ff3 modifier is also correct. “Constant” values in the format mask need to be enclosed in double quote So the … Read more
Pretty much all JVM-based timestamp mechanisms measure time as milliseconds since the epoch – so no, nothing standard** that will give seconds since epoch. Your function can be slightly simplified as: (quot (System/currentTimeMillis) 1000) ** Joda might have something like this, but pulling in a third-party library for this seems like overkill.
PowerShell’s Get-Date supports standard .NET time formats. The o round-trip format complies with ISO 8601. Like so, Get-Date -Format “o” 2017-08-15T12:10:34.4443084+03:00
See the following example: import datetime now = datetime.datetime.now() now.strftime(‘%Y-%m-%dT%H:%M:%S’) + (‘-%02d’ % (now.microsecond / 10000)) This could result in the following: ‘2017-09-20T11:52:32-98’
You could convert the underlying datetime64[ns] values to datetime64[s] values using astype: In [11]: df[‘Time’] = df[‘Time’].astype(‘datetime64[s]’) In [12]: df Out[12]: Record_ID Time 0 94704 2014-03-10 07:19:19 1 94705 2014-03-10 07:21:44 2 94706 2014-03-10 07:21:45 3 94707 2014-03-10 07:21:54 4 94708 2014-03-10 07:21:55 Note that since Pandas Series and DataFrames store all datetime values as … Read more
To populate the column during insert, use a DEFAULT value: CREATE TABLE users ( id serial not null, firstname varchar(100), middlename varchar(100), lastname varchar(100), email varchar(200), timestamp timestamp default current_timestamp ) Note that the value for that column can explicitly be overwritten by supplying a value in the INSERT statement. If you want to prevent … Read more
You can go Date->Calendar->set->Date: Date date = new Date(); // timestamp now Calendar cal = Calendar.getInstance(); // get calendar instance cal.setTime(date); // set cal to date cal.set(Calendar.HOUR_OF_DAY, 0); // set hour to midnight cal.set(Calendar.MINUTE, 0); // set minute in hour cal.set(Calendar.SECOND, 0); // set second in minute cal.set(Calendar.MILLISECOND, 0); // set millis in second Date … Read more
I wrote a custom deserializer to handle timestamps in seconds (Groovy syntax). class UnixTimestampDeserializer extends JsonDeserializer<DateTime> { Logger logger = LoggerFactory.getLogger(UnixTimestampDeserializer.class) @Override DateTime deserialize(JsonParser jp, DeserializationContext ctxt) throws IOException, JsonProcessingException { String timestamp = jp.getText().trim() try { return new DateTime(Long.valueOf(timestamp + ‘000’)) } catch (NumberFormatException e) { logger.warn(‘Unable to deserialize timestamp: ‘ + timestamp, e) … Read more