/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 vote335 views1 answer
Mysql concat and use as where column
SQL
25 votes352 views6 answers
Modify column name in mysql
SQL
0 vote375 views1 answer
000webhost database values insert
SQL
0 vote367 views1 answer
Sql date time query find
SQL
0 vote347 views1 answer
How to display value of variable in mysql
SQL
3 votes356 views1 answer
Uppercase and lowercase in sql
SQL
0 vote383 views1 answer
Google sheets data validation custom formula filter
SQL
0 vote393 views1 answer
Oracle winter time change
SQL
2 votes377 views2 answers
Calculate percentage in sql
SQL
8 votes337 views1 answer
Alter tablespace add datafile autoextend
SQL

Share