حضرت خواجہ سیدنا معین الدین حسن چشتی سنجاری اجمیری رحمۃ اللہ علیہ

Truncate the time from Datetime in sql

sri.s

I need query to truncate the time from datetime type in sql

EX: duedate(field)-datetime

12/06/2016 00:00:00(tis part has to be truncated. ie i need only date)

dharmend...

0 2

Refer the below query.

SELECT CONVERT(VARCHAR(20),CAST('12/06/2016 00:00:00' AS DATETIME),101) AS DueDate

OutPut

DueDate

12/06/2016

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

216.73.216.187