Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT *
- FROM invoice
- WHERE EXTRACT(DAY FROM CAST(invoice_date AS TIMESTAMP)) IN (1);
Advertisement
Comments
-
- Выгрузите из таблицы invoice всю информацию о заказах, оформленных первого числа каждого месяца. Не забудьте привести дату к типу timestamp.
Add Comment
Please, Sign In to add comment
Advertisement