Top "Timestamp" questions

Get Unix timestamp with C++

How do I get a uint unix timestamp in C++? I've googled a bit and it seems that most methods …

c++ unix timestamp uint

How do I get the unix timestamp in C as an int?

I would like to get the current timestamp and print it out using fprintf.

c unix timestamp epoch

Setting a JPA timestamp column to be generated by the database?

In my SQL Server 2000 database, I have a timestamp (in function not in data type) column of type DATETIME named …

java jpa persistence annotations timestamp

Need to get current timestamp in Java

I need to get the current timestamp in Java, with the format of MM/DD/YYYY h:mm:ss AM/…

java datetime format timestamp

Sqlite: CURRENT_TIMESTAMP is in GMT, not the timezone of the machine

I have a sqlite (v3) table with this column definition: "timestamp" DATETIME DEFAULT CURRENT_TIMESTAMP The server that this database …

sql sqlite timezone timestamp

Ruby/Rails: converting a Date to a UNIX timestamp

How would I get a UNIX timestamp (number of seconds since 1970 GMT) from a Date object in a Rails app? …

ruby-on-rails ruby date timestamp

Why there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT clause?

Why there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause? CREATE TABLE `foo` ( `…

mysql timestamp mysql-error-1293

How to have an automatic timestamp in SQLite?

I have an SQLite database, version 3 and I am using C# to create an application that uses this database. I …

c# sqlite timestamp

MySQL CURRENT_TIMESTAMP on create and on update

I want to define table which will have 2 TIMESTAMP fields, someting like this: CREATE TABLE `msgs` ( `id` INT PRIMARY KEY …

mysql timestamp mysql-error-1293

Using current time in UTC as default value in PostgreSQL

I have a column of the TIMESTAMP WITHOUT TIME ZONE type and would like to have that default to the …

postgresql timezone timestamp