Answers

How to convert a datetime into short time format in SQL Server 2005?

Avijit Chakraborty

15y

18.1k

I want to display the time in hh:mm AM/PM format.

Example: 10:23 PM

How to display that?

Answers (3)

Next Recommended Forum

conversion date problem

Leaderboard

View all

Deepak Tewatia

Aryan Kumar

-1

Baibhav Kumar

View all

Yesterday's leader

HTMLCSSJAVASCRIPTPUTHONANGULARBIGDATAC++

Delhi (India)

500

Member of the month

Chennai (India)

Speaker of the month

C#, .NET

Chitrakoot (India)

Upcoming events

View all

Suggested for you

View all

John Miller

Allen James

Harshit Pandey

Rinki

Forum Statistics

Please welcome our newest member Grace Lee.
2,380,749 users have contributed to 122,527 threads and 388,993
In the past 24 hours, we have 0 new threads, 0 new posts, and 0 new users.
In last week, the most popular thread is 'How can I optimize my Twilio SMS usage to reduce costs?'.