Most voted "timestamp" questions
A timestamp is the moment an event is recorded by a computer system. The term timestamp may also refer to Unix Time or to the timestamp data type.
Learn more…82 questions
Sort by count of
-
1
votes3
answers7344
views -
1
votes1
answer224
viewsPostgres: Error converting date in Postgres 10
When I perform a date conversion on postgres 9.6 that I have on my machine, it fixes the date if it is invalid, the same is not happening on postgres 10 that is on another machine: Postgres 9.6…
-
1
votes1
answer490
viewsData with PHP + SQL doing operations
I have some questions: I need to save two dates in the same database table, and I will need to do a function to compare the dates later. Actually I already have a test of it ready, but I thought I…
-
1
votes1
answer152
viewsWhat kind of data to store "2019-02-06T14:14:38+00:00"?
I am consuming an API that returns me a field date with that data: 2019-02-06T14:14:38+00:00 In my Mysql database I created a field timestamp, because he was the only close I could find. Well, I can…
-
1
votes1
answer118
viewsError using firebase.firestore.Fieldvalue.serverTimestamp() method in an array
I am creating a system of questions and answers, and in this system and this system I need the answers to enter an array with the name of the respondent, the value of their response and the…
-
1
votes1
answer57
viewsPostgresql: How to select a field based on the maximum value of another field?
I have a table with the following configuration: create table baixas_do_requerimento as codigo_requerimento text, tipo_baixa text, data_baixa timestamp Each código_requerimento can repeat numerous…
-
0
votes1
answer154
viewsSelect date before searching
I’ve tried to do a lot of things but none of them worked out, okay. I need to make a date filter to facilitate searches, even setting a specific date ends up that all results are shown, I want to…
-
0
votes1
answer42
viewsDecrypting date
I have a dashboard, and it encrypts the date, and I was wondering how I can decrypt it to show on my website. Encrypted date: 1437619904 I wanted to put it to the normal way.
-
0
votes2
answers103
viewsdata conversion problems with php
I have the following function that transforms timestamp into English readable date function dataEmPortugues ($timestamp, $hours = TRUE, $timeZone = "America/Sao_Paulo") {…
-
0
votes0
answers228
viewsWhy is the timestamp field in the Firebird database displayed differently in a Ruby on Rails application?
I have a database Firebird 2.5 legacy. Access it via IBExpert 2016.9.4.1 This database is part of a request management system that is being migrated from an application Delphi 10.1 Update 2 for an…
-
0
votes1
answer149
viewsDoubt Javascript Date() [front-end]
I’m building a personal blog using Github Pages and a desktop app con NWJS to do the back-end administration however I have a big question when presenting dates on the front-end. As it comes to a…
-
0
votes1
answer47
viewsDate on a Highstock Chart
I’m trying to create a graph with the framework Highcharts, to create a chart, which framewor itself makes available, highstock. I’m trying to generate a graph like line, the values are correct, but…
-
0
votes2
answers1081
viewsmultiples Timezone php
Well, I have a system where I need to use a timestamp in UTC format, and I use a system to show when the profile was visited on the site, and I update it with a timestamp, but I have a problem, on…
-
0
votes0
answers35
viewsDisplay the same metric for Prometheus but with different timestamps
I want to expose several metrics with their respective timestamps for Prometheus, for example: test5{job_name="test05"} 15 1512982800000 test5{job_name="test05"} 10 1512986400000…
-
0
votes1
answer867
viewsView day of the week as date used in PHP query
Good afternoon everyone, I’m having a question on a course project. I have a form where I look for scheduled patients on a certain day of the month. When I perform the appointment to present the…
-
0
votes1
answer144
viewsUnix Time for Tdatetime
I need to convert a received time into a json in the format 750382 for 00:12:41 in Delphi has the function Unixtodatetime() but it only works if I receive the full date and time, but in this case I…
-
0
votes0
answers111
viewsConfigure Mysql to accept reset TIMESTAMP
I’m migrating a database from SQL Server to the Mysql. On migration it gives error when it will popular tables on MYSQL TIMESTAMP. Incorrect datetime value ( 2007-10-21 00:00:00.000000 ) When du um…
-
0
votes0
answers42
viewsTO_TIMESTAMP in Oracle Packages
I was doing some maintenance on object database oracle 11g, but in the middle of this adventure I ended up compiling and recompiling versions that gave error. I wonder if there is any way to perform…
-
0
votes1
answer153
views -
0
votes1
answer67
viewsTimestamp or datetime calculate Lifetime/diff (php)
Hello, I’m trying here how to do for this value "147878163" be converted to "1 day 17 hours 15 minutes" for example Apparently it’s timestamp, but this value is different from what I usually use,…
-
0
votes1
answer322
viewsDate does not "respect" PHP formatting
I gave a search and found no solution to the problem, I really think it should be something simple that maybe I’m wrong. In the system users can insert some files via intranet, when they insert the…
-
0
votes2
answers73
viewsSelect MAX with the Unix Timestamp field
I have a database in which tables have a Timestamp column (column name) which is int type, where I store the value in Unix Timestamp format. I’m trying to give a select on the most recent date.…
-
0
votes2
answers222
viewsSave Date.now() to postgres
Hello, I would like to know what kind of data I use in the time column of my table, which will store the Date.now() from Javascript, it returns an integer like this 1591181717431. I thought to use…
-
0
votes0
answers31
viewsInvalidpipeargument error when using Datepipe
I’m making an application in Angular and I’m trying to show a date, coming from the database, in a table. I have a database, as I mentioned above, which has a field for storing dates, like…
-
0
votes1
answer219
viewsHow to take only the time of a Timestamp
Using the command below: pd.to_datetime(1490195805, unit='s') The return is: Timestamp('2017-03-22 15:16:45') How do I extract only the time: 15:16:45?…
-
0
votes1
answer292
viewshow to get the minimum average and maximum time of a timeseries with pandas, based on a column where the value is boleano?
I’m analyzing a timeseries returned with pandas ex: index----valor------timestamp <br> ----0 -------0-------- 2019-04-23 16:14:34.142540+00:00<br> ----1 -------0-------- 2019-04-23…
-
0
votes2
answers68
viewsI can’t get the right timestamp time
I have an API I’m consuming and in it I have the field timestamp worthwhile 1604327859 and with that value I have the following time and date: This value above is correct, I am using the Moment.js…
-
0
votes1
answer41
viewsWhy when creating a zoo series object the columns change from Numeric or integer to Character?
Good evening!!! I am confused enough. I will explain the pass-by-step until I get to the doubts that I finally could not solve: My goal is to create a file where tickers quotes are stored where each…
-
-1
votes1
answer93
viewsHow to customize the Doctrine library to work with the Timestamp type
I’m using Composer with Doctrine in my application, and it’s getting wonderful. But I need to customize some Doctrine features, changing the classes Doctrine\DBAL\Platforms\AbstractPlatform and…
-
-1
votes1
answer635
viewsHow to insert timestamp value into a Mysql table?
I am receiving a timestamp value from a request, and would like to store this value in my bank, however I want the column to interpret it correctly. The value is 1416178487. And using the function…
-
-1
votes1
answer152
viewsSort timestamp results just by time?
I am trying to make a time ranking system of a game. The game uses UNIX time as a measure of time. I need to put the minor times first in ascending order, but as UNIX time includes date as well,…
-
-4
votes3
answers343
viewsHow to check if the timestamp is today?
I have a JSON obtained from an API that returns a list of events like this: Array ( [alertList] => Array ( [alerts] => Array ( [0] => Array ( [id] => 145392039 [name] => Failed…