/SQL/Sql server add time to date

Sql server add time to date

Add time to date sql

ADDTIME(NOW(),'5:30:00')

1

Sql server add time to date

DECLARE @date DATETIME
SET @date='2010-10-01'
SET @date=@date+'15:00:00'
SELECT @date AS DATETIME

0

Similar codes

3 votes179 views1 answer
Search for column name in psql
SQL
0 vote203 views1 answer
Big table in mysql
SQL
0 vote248 views1 answer
Reset a table's identity column and remove test records
SQL
53 votes586 views6 answers
How to install mysql ubuntu
SQL
0 vote241 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
3 votes289 views1 answer
Oracle show trigger code
SQL
10 votes142 views2 answers
Django mysql
SQL
1 vote210 views1 answer
Alter database datafile maxsize 32g
SQL
1 vote181 views1 answer
Importance of comment in mysql
SQL
2 votes195 views1 answer
Pdo mysql insert
SQL

Share