datetime conversion in sql

Anu

3y1.1kSQL

Hi,

I want to convert 'Wed Sep 13 2023 00:00:00 GMT+0530 (India Standard Time)' to datetime in sql. the requirement is to compare this date with Getdate(). Please suggest a way to convert this to datetime

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ali Benchaaban3y ago

Accepted answer

DECLARE @inputString NVARCHAR(100) = 'Wed Sep 13 2023 00:00:00 GMT+0530';
DECLARE @convertedDateTime DATETIME;

SET @convertedDateTime = CONVERT(DATETIME, SUBSTRING(@inputString, 5, 20), 9);

IF @convertedDateTime > GetDate()
BEGIN
    PRINT 'your message here';
END
ELSE
BEGIN
    PRINT 'your message here';
END

Ajay Kumar3y ago

DECLARE @inputString NVARCHAR(MAX) = 'Wed Sep 13 2023 00:00:00 GMT+0530 (India Standard Time)'

-- Extract relevant parts from the input string
DECLARE @day NVARCHAR(3) = SUBSTRING(@inputString, 1, 3)
DECLARE @month NVARCHAR(3) = SUBSTRING(@inputString, 5, 3)
DECLARE @dayOfMonth INT = CAST(SUBSTRING(@inputString, 9, 2) AS INT)
DECLARE @year INT = CAST(SUBSTRING(@inputString, 12, 4) AS INT)
DECLARE @time NVARCHAR(8) = SUBSTRING(@inputString, 17, 8)

-- Create a datetime value
DECLARE @formattedDate NVARCHAR(30) = CONCAT(@month, ' ', @dayOfMonth, ', ', @year, ' ', @time)
DECLARE @convertedDate DATETIME = CONVERT(DATETIME, @formattedDate, 0)

-- Compare with GETDATE()
SELECT @convertedDate AS ConvertedDate
WHERE @convertedDate = GETDATE()