/SQL/Timestamp in sqlite

Timestamp in sqlite

Timestamp in sqlite

CREATE TABLE MyTable(
    ID INTEGER PRIMARY KEY,
    Name TEXT,
    Other STUFF,
    Timestamp DATETIME DEFAULT CURRENT_TIMESTAMP
);

1

Similar codes

0 vote318 views2 answers
How to install mssql on mac
SQL
0 vote484 views1 answer
Sql change a colum to unique
SQL
8 votes319 views3 answers
Connect python to mysql
SQL
0 vote324 views1 answer
Psql show db
SQL
10 votes276 views1 answer
Oracle dependency
SQL
2 votes311 views2 answers
Run mysql command from bash
SQL
1 vote306 views1 answer
Postgresql delete cascade
SQL
9 votes308 views3 answers
Show table columns mysql command line
SQL
3 votes326 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
1 vote294 views1 answer
List index mysql cli
SQL

Share