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
7
Answers
How to insert time only from datetime in C# and sql
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
siva nathan
7y
705
1
Reply
i have a grid like below i want to insert a time only from a datetime
intime
outtime
01-01-2017 08:45:12
01-01-2017 20:00:12
01-02-2017 08:45:12
01-02-2017 18:45:12
my expected result is i want to store only time in sql column
08:45:12
20:00:12
08:45:12
18:45:12
pls explain in both C# and sql
what kind of datatype i have to use to store time only in sql column
Post
Reset
Cancel
Answers (
7
)
Next Recommended Forum
How stop the overlapping of the html table
Exiting a console app from deep in the code