Авторизация:
E-Mail: Пароль:
Закрыть
RU | EN

qwe321123

Опубликовано: 2019-09-10 13:24:59
Этот текст доступен по адресу: http://ontext.info/115980
In the query pane, type the following query after the task 1 description:
SELECT
CURRENT_TIMESTAMP AS currentdatetime,
CAST(CURRENT_TIMESTAMP AS DATE) AS currentdate,
CAST(CURRENT_TIMESTAMP AS TIME) AS currenttime,
YEAR(CURRENT_TIMESTAMP) AS currentyear,
MONTH(CURRENT_TIMESTAMP) AS currentmonth,
DAY(CURRENT_TIMESTAMP) AS currentday,
DATEPART(week, CURRENT_TIMESTAMP) AS currentweeknumber,
DATENAME(month, CURRENT_TIMESTAMP) AS currentmonthname;

Зарегистрируйтесь на ontext.info для получения дополнительных возможностей по работе с сервисом.