Top "Timestamp" questions

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

ORA-01810: format code appears twice

Why is the sql below generating an ORA-01810 error? I researched the error and I am using different date formats …

sql oracle timestamp date-formatting
Given a Unix timestamp, how to get beginning and end of that day?

I have a Unix timestamp like this: $timestamp=1330581600 How do I get the beginning of the day and the end …

php timestamp strtotime unix-timestamp
Obtaining a Unix Timestamp in Go Language (current time in seconds since epoch)

I have some code written in Go which I am trying to update to work with the latest weekly builds. (…

unix timestamp go
Javascript Date.toString() formatting?

Possible Duplicate: Formatting a date in JavaScript I have the following piece of script. It's a HTML5 slider with a …

javascript date timestamp tostring
Now() without timezone

I have a column added_at of type timestamp without time zone. I want it's default value to be the …

postgresql timestamp postgresql-9.2
How to get current timestamp with CQL while using Command Line?

I am trying to insert into my CQL table from the command line. I am able to insert everything. But …

cassandra timestamp cql datastax-java-driver
How to create mysql table with column timestamp default current_date?

I need to create mysql table with default value on column CURRENT_DATE() I try DROP TABLE IF EXISTS `visitors`; …

mysql sql datetime timestamp create-table
How do I alter a mysql table column defaults?

I have a table with a column of type timestamp which defaults current_timestamp and updates to current_timestamp on …

mysql database timestamp alter
long timestamp to LocalDateTime

I have a long timestamp 1499070300 (equivalent to Mon, 03 Jul 2017 16:25:00 +0800) but when I convert it to LocalDateTime I get 1970-01-18…

java java-8 timestamp java-time
MySQL ON UPDATE CURRENT_TIMESTAMP not updating

I've got a table that looks like this: CREATE TABLE IF NOT EXISTS `Hosts` ( `id` int(128) NOT NULL AUTO_INCREMENT, `…

mysql sql timestamp sql-update