How to set time to 00:00:00 with GETDATE() in SQL
By FoxLearn 2/12/2025 2:11:43 AM 873
1. Using CAST
You can cast the result of GETDATE()
to a date
type and then back to datetime
type, which will automatically set the time to 00:00:00
.
For example:
// sql time getdate date SELECT CAST(CAST(GETDATE() AS date) AS datetime) //2024-10-07 00:00:00.000
2. Using CONVERT
You can use the CONVERT
function similarly.
For example, sql getdate with 00 time
SELECT CONVERT(datetime, CONVERT(date, GETDATE())) //2024-10-07 00:00:00.000
3. Using DATEADD
If you want to explicitly set the time to midnight while keeping the date part from GETDATE()
, you can use DATEADD.
For example:
SELECT DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()), 0) //2024-10-07 00:00:00.000
All the above methods will return the current date with the time set to 00:00:00
. You can choose any of the methods above based on your preference.
They all effectively achieve the same result of getting the current date with the time portion set to midnight.
- How to Download and Restore Northwind database to SQL Server
- How to fix 'The transaction log for the database is full due to ACTIVE_TRANSACTION'
- How to use ROW_NUMBER Function in SQL Server
- How to Convert varchar to uniqueidentifier in SQL Server
- How to convert varchar to integer in MySQL
- How to change ‘Edit Top 200 Rows’ and ‘Select Top 1000 Rows’ in SQL
- How to fix 'The transaction log for the database is null due to OLDEST_PAGE'
- How to convert timestamp to date in SQL Server