Questions tagged as 'timestamp'

Tagged questions
2
answers

Should I use a DateTime or TimeStamp type field in mySQL?

I must save dates and times in different tables of a typical transactional application where I will store varied information, such as: Dates and times at which each transaction occurs (Invoice, Payment Receipt, etc.) Dates and times of fut...
asked by 02.11.2015 / 16:27
2
answers

Convert a date to a timestamp?

How can I get a date in PHP format in timestamp ? $fecha = "2015-12-06"; echo TIMESTAMP($fecha);     
asked by 06.12.2015 / 10:17
1
answer

Javascript - Convert a Timestamp string to human date format

I have the following information: Timestamp: 1481751645.455596 I want to convert it to the following format: Wed, 14 Dec 2016 21:40:45 GMT. I used the following website: link to be able to verify that the Timestamp format that I show you...
asked by 15.12.2016 / 13:44
1
answer

Mysql get the next Monday at noon

Hello friends, could you help me with the following: I have a field with a timestamp format and I would like to know how to get the next Monday at midday to save it in date_end . journay date_start date_end 1 1515200400 1...
asked by 24.01.2018 / 02:57
2
answers

help with the UNIX_TIMESTAMP function in mysql

I am using the UNIX_TIMESTAMP function to convert a date to unix format. The date is this: 2018-04-16 12:00:00 when I use UNIX_TIMESTAMP('2018-04-16 12:00:00'); returns 1524225600 that is equal to 2018-04-...
asked by 19.04.2018 / 20:14
1
answer

Save date in unix format in Mysql

I need to store records with field in date and time in Unix format by default in a mysql table, is it possible to do that? Can you create a table with this field by default?     
asked by 01.09.2018 / 02:52
1
answer

dates timestamp problems when converting

I have stored the "dates" (it is a varchar) and I need to take it to another format to do operations, and many poor options and the one that seemed to help me dateformat arrogates values to me in zeros, I also have to keep the hours and minutes...
asked by 19.04.2018 / 18:35
2
answers

Convert UNIX TIMESTAMP to DATE in Oracle

I need to convert a unix timestamp that is stored in a column of data type VARCHAR2 to a data type DATE. Example .. 1404316382 = 2014-07-02 15: 53: 02.000 Any ideas?     
asked by 26.04.2016 / 19:12
2
answers

What java object to use to insert a date in a PostgreSQL timestamp field

I am working with a PostgreSQL database , in which I have a field of type timestamp since I only want a date with its time (no time zone ). To do the saving I am making use of the object LocalDateTime of Java 8. The ques...
asked by 23.07.2018 / 12:30
1
answer

Timestampdiff does not work in Clause Where

I'm doing a query to the database and I want to show me only the records in which the difference between the query time (NOW()) and the time of the datetime variable is less than 60 minutes ... (which shows everything that is more than on...
asked by 24.02.2017 / 03:46