Computer scienceFundamentalsSQL and DatabasesDBMSSQLite

Date and Time data types in SQLite

Time zone update

Report a typo

Choose the correct option converting UTC timestamp from '2099-05-03 12:00:00' into '+5 hours' timezone and returning it in 'YYYY-MM-DD HH:MM:SS' format.

Select one option from the list

SELECT strftime('%Y-%m-%d %H:%M:%S', datetime('2099-05-03 12:00:00', 'utc', '+5 hours'));

SELECT datetime('2099-05-03 12:00:00', 'utc', '+5 hours'));

SELECT strftime('%Y-%m-%d %H:%M:%S', datetime('2099-05-03 12:00:00', 'localtime', '+5 hours'));

SELECT CONVERT_TZ('2099-05-03 12:00:00', 'utc', '+5 hours'));

___

Create a free account to access the full topic