Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
3
Reply
time formate conversion to am pam
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
piyusha patravali
11y
797
1
Reply
Hello can any one help me to retrieve value from database saved in datetime format to HTML5 input type time control.
I tried to use
select REPLACE(REPLACE(CONVERT(varchar, CAST('1900-01-01 23:28:00' AS time) ,100),'AM',' AM'),'PM',' PM')
but it gives error
Type time is not a defined system type.
I want output as
11:28:00 PM
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
Add New Item in GridView
How to store one by one data dynamically in DetailsView???