Top "Timestamp" questions

A timestamp is the time at which an event is recorded by a computer system.

How to use a case-when statement in a mysql stored procedure?

I want to set the session_id automatically using the request_time parameter so i opted for a mysql stored …

mysql timestamp procedures case-when
Convert RSS pubDate to a timestamp

How to convert a date string Mon, 24 May 2010 17:54:00 GMT from RSS feed to a timestamp in PHP ?

php rss timestamp pubdate
Using MySQL's TIMESTAMP vs storing timestamps directly

I'm in a dilemma about saving date and time values in MySQL's TIMESTAMP format vs in a custom UNSIGNED INT …

php mysql datetime timestamp unsigned-integer
Importing .csv with timestamp column (dd.mm.yyyy hh.mm.ss) using psql \copy

I'm trying to import data from a .csv file into a postgresql 9.2 database using the psql \COPY command (not the …

postgresql csv timestamp psql postgresql-9.2
How to combine date and time into a timestamp in db2?

In a db2 database I have a DATE column and a TIME column, how can you combine these into a …

sql date time db2 timestamp
Date and time in UTC - how to store them in postgres?

I am getting my data: date and time in UTC, in a csv file format in separate columns. Since I …

postgresql date time timestamp timestamp-with-timezone
Convert milliseconds to Timestamp

I know that to convert a Unix timestamp in milliseconds to an SQL timestamp I can use SELECT TO_DATE(…

sql oracle timestamp unix-timestamp milliseconds
Creating a unique timestamp in Java

I need to create a timestamp (in milliseconds) in Java that is guaranteed to be unique in that particular VM-instance. …

java concurrency timestamp epoch throttling
Embed timestamp in object code at compile time with C++

I want to perform a printf() to display when the currently executing code was last compiled. Does C/C++ provide …

c++ build timestamp versioning
How to write bigint (timestamp in milliseconds) value as timestamp in postgresql

I'm trying to store in timestamp with timezone field my value. It is in milliseconds from 1970. select TO_CHAR(TO_…

postgresql timestamp unix-timestamp milliseconds bigint