Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
[ad_1]
I’m trying to calculate the time remaining based on a target date. I have a target date of “July 4, 2022 10:00:00” and I want to subtract that from today’s date.
I first did SET @var_name = “July 4, 2022 10:00:00”
followed by SELECT datediff(now(),@var_name) but it keeps returning a null value. Is there a way where I can have it display the number of days, hours and minutes remaining from the target date?
[ad_2]
