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

Store DateTime with AM and PM SQL Server Table

Vasanth

Hi

I can able to get the datatime in the following format.

9/27/2012 1:35:00 PM

how do i store this valie in the table in the sql.

Please let me know if this is not clear.

Thanks.

Mudassar

0 1

No you cannot, in SQL Server the DateTime is 24 hour format. You can easily Format DateTime as needed in code

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