Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

Time conversion format

Home
Forums
SQL

Time conversion format

Sukaskha

6yAsked Jul 21, 2020, 6:38 PM945SQL

Hi all,

How can I convert or cast AM/PM time format to 24 hour clock format? Any help would be appreciated.

4 Replies

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

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Shweta Lodha6y ago
Accepted answer
Many suggestions are given over here:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/8c74a997-0b43-4fb5-840a-ae9642f0d726/varchar-ampm-field-to-military-tme?forum=transactsql
+2
Ashutosh Gupta6y ago
1. DateTime dt = DateTime.Parse("03:30 AM");
2. DateTime timeValue = Convert.ToDateTime("03:30 PM");
3. DateTime date = DateTime.ParseExact("03:00 PM" , "h:mm tt", CultureInfo.InvariantCulture).ToString("HH:mm");
+1

Roshan Rathod

Roshan Rathod6y ago

check this link : https://www.geeksforgeeks.org/program-convert-time-12-hour-24-hour-format/

+1

thanks for very fast response.

+1