Questions tagged as 'timestamp'

Tagged questions
2
answers

Problems converting data mon dd yyyy hh: mm

I made a select in SQLSERVER within php: mssql_query(SELECT TOP 1 ven.DATA FROM tab_venda ven (nolock) INNER JOIN dbo.tab_item_venda iven (nolock) ON iven.num_Venda = ven.NUM_VENDA...
asked by 24.09.2015 / 16:57
1
answer

How to change a table indicating that the data of a certain field can only vary from date 1 to date 2?

I have a table called "LOC_VEICULO" where the vehicle data is contained. In it I have the following field: DT_FABRICATION (DATE), where the manufacturing dates of the vehicles are stored. I need to change the vehicles, indicating the dates of...
asked by 10.09.2017 / 05:25
1
answer

Insert data in mysql, in a field of type timestamp

How do I enter information in a field of this type? The field name is duration, I would like an example ..     
asked by 28.04.2016 / 01:02
1
answer

Postgres: Error converting data in Postgres 10

When I run a date conversion on postgres 9.6 that I have on my machine, it corrects the date if it is invalid, the same is not happening in postgres 10 that is on another machine: Postgres 9.6 DateStyle = ISO, DMY server_encoding = UTF8...
asked by 26.12.2018 / 18:53
3
answers

Convert time stamp to full date with php [duplicate]

I have a field with timestamp datetime in my bank and I need to convert timestamp to this example format:    WEDNESDAY, DECEMBER 31, 1969 posted at 15:30 I searched here and found a code, but I can not make it work, it r...
asked by 25.10.2016 / 21:13
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

Update date for each update in a table

I have a pessoa table. In it I have a field called pe_modified that aims to have the date of the last modification in the table. Instead of having to refresh in the query, is it possible to be automatic? Is there any type of fie...
asked by 22.11.2016 / 15:23
1
answer

Decrypting date

I have a panel, and it encrypts the date, and wanted to know how I can decrypt it to show on my site. Encrypted date: 1437619904 I wanted to put it in the normal way.     
asked by 24.07.2015 / 10:47
2
answers

problems with date conversion with php

I have the following function that transforms timestamp into a readable date in Portuguese function dataEmPortugues ($timestamp, $hours = TRUE, $timeZone = "America/Sao_Paulo") { $timestamp=strtotime($timestamp); $dia_num = date("w", $ti...
asked by 30.11.2016 / 18:14
1
answer

Display day of the week, according to the date used in the PHP query

Good afternoon everyone, I have a question in a course project. I have a form where I look for patients scheduled on a particular day of the month. When I perform the query to present the scheduled patients, I must also present the day of the...
asked by 20.12.2017 / 19:05