Tools

1. MesaSQLite for MacOSX.

SQL

1. Getting the current time

MySQL = Now();

SQLite3 = CURRENT_TIMESTAMP;

insert into jobstemp(full_address, datecreated, dateupdated)
VALUES("9 Bishop Street", CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);

2. Getting the local current time

SELECT datetime(dateupdated, 'localtime')

3. Trim

SELECT trim(name) FROM table