Here’s some example to get the date part in sql with datetime data type :
1 | DATEADD(dd, 0, DATEDIFF(dd, 0, [yourdate])) |
or
1 | CONVERT(date, [yourdate]) |
SQL Query Get Date Only For The Date Part
Reply
Tag Archives: SQL Query
SQL Query Get 2nd Row Data
Here’s example to get 2nd row data with sql query
1 2 3 4 5 6 7 | ;WITH YourCTE AS ( SELECT TOP 2 *, ROW_NUMBER() OVER(ORDER BY [YourColumn]) AS RowNumber FROM [YourTable] ) SELECT * FROM YourCTE WHERE RowNumber=2 |
Convert Int to String SQL Query
To convert int or any number to string in sql query we can use :
1 | CAST([datatoconvert] as VARCHAR(50)) as exp1 |
Or
1 | CONVERT(VARCHAR(50), [datatoconvert]) as exp1 |
SQL Query For Reset Table Identity
This is SQL Query for resetting Table Indentity :
1 | DBCC CHECKIDENT ([Table_Name], reseed, Reset_Number_To) |
place your Table Name in [Table_Name] and replace Reset_Number_To with number you want to start the identity for the next record, for example if you want your identity number start from 1, you replace Reset_Number_To with 0
MSSQL Query Two Digit Year, Month, and Date
Here’s some SQL Query to get Two Digit Year, Month and Date
Year :
1 | print right(year(getdate()), 2) |
result :
11
Month :
1 | print right('0' + month(getdate()), 2) |
result :
03
Date :
1 | print right('0' + day(getdate()), 2) |
result :
26