Questions tagged as 'timestamp'

4
answers

How to check events between 2 dates in MySQL?

Knowing that I have a table called eventos , and this table has the columns id , titulo , inicio and fim . The inicio and fim columns are of type timestamp , where the start and end date and time of...
asked by 04.02.2014 / 20:30
5
answers

How to get TimeStamp in Javascript?

Would you like to know how to Javascript to get Timestamp ? A number that represents the current date and time. I know we get the object for date and time through: var d = new Date(); But I do not know how to proceed from here....
asked by 17.12.2013 / 17:39
1
answer

ORDER BY only day without time

In MySQL I have a column timestamp called dia_cadastr o (2016-06-21 11:27:32), in the query I want to give a ORDER BY only on the day, and disregard the time. That is, if they have products registered the same day, then it g...
asked by 24.06.2016 / 15:07
4
answers

"Date.now ()" equivalent of Javascript in C #?

Here talks about getting milliseconds using Date.now(); , which returns something like 1533144170651 . Follow his documentation:    The now () method returns the milliseconds since 1 January   1970 as of 00:00:00 UTC so far...
asked by 01.08.2018 / 19:38
2
answers

Use timestamp with or without timezone in postgresql?

Use timestamp with or without timezone in Postgres? The Web application will be used in different countries, so I will have to deal with different time zones. The system has data entry of several different objects that have the day and time t...
asked by 24.08.2017 / 20:54
2
answers

timediff () limited to 838: 59: 59, how to solve?

DBMS: MYSQL Problem: I am adding HOURS to a TIME field type, and the expected result is above 838: 59: 59, but it is visible only up to this limit. How to solve? SELECT he.empresa, SEC_TO_TIME(SUM(TIME_TO_SEC(CASE WHEN time...
asked by 14.04.2014 / 19:30
1
answer

How to convert a value in UNIX type Timestamp to DateTime?

How to convert a value to type UNIX timestamp (seconds since 1970) , example 1396148400 , in a DateTime ?     
asked by 13.04.2014 / 01:01
2
answers

How to convert a string with minutes / month / year in TimeStamp?

I am making a test code only. In it, I have the following String : String tempo = "1s"; //1 segundo This string is modified all the time: String tempo = "30d"; //30 dias So, I want to convert this string which can be s(segun...
asked by 10.12.2016 / 16:25
3
answers

How to convert timestamp from the database to populate a datetime-local field?

I need to fill in a field: <input id="date" type="datetime-local" class="form-control" value="{{$task->date}}" name="date"> The return comes in timestamp format, 2016-09-20 10:00:00 ), there is some helper in> laravel to conv...
asked by 19.09.2016 / 16:26
3
answers

Save date in Brazilian format in Postgresql

I have a PostgreSQL database on the Windows Azure server that is set to the Brazilian standard. If I do a SQL and execute directly on PgAdminIII from the server and execute, the date is saved in the Brazilian format. But if I have my C # c...
asked by 10.05.2017 / 02:46