-----Ursprungligt meddelande-----
From: Baruch Burstein
Sent: Sunday, November 04, 2012 10:43 AM
To: Григорий Григоренко ; General Discussion of SQLite Database
Subject: Re: [sqlite] SUGGESTION: "now" as alias for "strftime('%s','now')"
CURRENT_TIMESTAMP returns "YYYY-MM-DD HH:MM:SS", not a unix timestamp. I
think other DB systems all use this function to return a unix timestamp.
----- Reply -----
There might be some that does, but
Oracle11g
SQL> select CURRENT_TIMESTAMP from dual;
CURRENT_TIMESTAMP
---------------------------------------------------------------------------
2012-11-04 11:05:23,537000 +01:00
Oracle9i
SQL> select CURRENT_TIMESTAMP from dual;
CURRENT_TIMESTAMP
---------------------------------------------------------------------------
2012-11-04 11:08:48,942211 EUROPE/STOCKHOLM
MySQL 5
mysql> select CURRENT_TIMESTAMP;
+---------------------+
| CURRENT_TIMESTAMP |
+---------------------+
| 2012-11-04 11:06:31 |
+---------------------+
Regards
Roger
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
