Questions tagged as 'timestamp'

Tagged questions
1
answer

Convert timestamp value to date

I have a timestamp value of a date, 1389135600 , how can I convert this value to a date of this type 27/12/2014 .     
asked by 27.12.2014 / 12:38
1
answer

Timestamp automatically update with current date

I would like to know if it is possible to automatically update the value of another TIMESTAMP column called date with the current date and time, similar to% the INSERT function of MySQL?     
asked by 03.01.2015 / 21:00
2
answers

Handling dates in AWK scripts

CONTEXT: I have a CSV file from which I want to extract and process some columns. I realized that AWK would be the perfect tool for this and everything went well until I had to deal with timestamps - for example 2008-07-31T21: 42: 52.667...
asked by 07.08.2014 / 17:26
2
answers

Java Timestamp and MySQL Timestamp

Problem: I am storing a timestamp in MYSQL, but when I redeem this timestamp I am losing the thousandths. Java timestamp with thousandths. MYSQLtimestampwithoutthousandths. Why does this occur? How to solve this? I need the return...
asked by 19.08.2014 / 16:15
2
answers

Convert date to Unix timestamp

I have a table in a MySQL database that has a date column VARCHAR , type 20-09-2017 and I need to migrate this column to a bigint(8) column that uses the Unix date format timestamp . How to do this?     
asked by 20.09.2017 / 14:35
1
answer

Convert date and time to numeric value in JavaScript

I saw in kibana , the dates are treated as numeric values, for example, the date: 2016-05-03T10:00:00 is equal to the numeric value: 1462280400000 . I would like to understand how this works, and what function it can convert.     
asked by 03.05.2016 / 15:26
1
answer

How to convert from Timestamp to Calendar?

I need to convert a resultSet of the database that returns Timestamp to a variable of type Calendar.     
asked by 04.06.2015 / 22:34
1
answer

Picking up TimeInMillis and using Timestamp

Doubt: I know two ways and capturing a TimeInMillis() does anyone know the difference and which one is the most efficient? What if there is a third way to capture this value? Option 1: System.out.println(Calendar.getInstance(...
asked by 28.02.2014 / 14:56
2
answers

Check if a sequence of numbers corresponds to a valid timestamp

I need to check if a string matches a valid timestamp. Using is_numeric , ctype_digit , will only validate if it is numeric ... I want to know if the timestamp matches a date.     
asked by 27.07.2014 / 05:15
2
answers

SQL to compare hours and minutes when Timestamp in PostgreSql

I am trying to compare 2 timestamp fields, which have different dates, ignoring the dates and using only the hour / minute simultaneously, to know, within one day which one is larger. EX: '2000-10-10 10:00:22' > '2000-02-02 11:00:10' In...
asked by 12.01.2017 / 00:24