How to create query in sql?

A

Anton Plawkevich2017-03-13 21:09:51

SQL

Anton Plawkevich, 2017-03-13 21:09:51

Help with the query , Find how many days left until the end of the year.
I need help with a query in sql, namely how to correctly implement this task, thanks.

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Anton Plawkevich, 2017-03-13
@antowa_plawkevich

SELECT DATEDIFF(day,GETDATE(),'@date') - thanks everyone, figured it out

Similar questions

B

Bodrosh2018-02-10 09:39:13

Why is the function not returning the value correctly in the WHERE clause? 1Reply

S

sp9999992021-06-16 14:00:53

How to execute a subquery in SQL (SELECT passing parameter from main query? 2Reply

T

Tiyzz2018-02-12 10:57:59

How to check records in database? 2Reply

A

alexey_khorin2021-06-17 14:11:40

How it is possible to make that from druh tables the information united in one? 1Reply

Y

Yaroslav2018-02-13 14:44:30

Why does the Unknown column 'iblock_props.PERIOD' in 'where clause' error occur? 2Reply

Didn't find what you were looking for?

Ask your question