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.

Datetimepicker format insert into sql problem

Home
Forums
Learn iOS Programming

Datetimepicker format insert into sql problem

Goran Bibic

8yAsked May 9, 2018, 3:06 AM716Learn iOS Programming

Datum sql format is date

Vrijeme poziva is sql format time(7)

"INSERT INTO dbo.registar (datum, vrijeme_poziva)" +
" VALUES ('" + datumDateTimePicker.Value.Date.ToString("yyyyMMdd") + "', '" + vrijeme_pozivaDateTimePicker.Value.TimeOfDay.ToString("HHmmss") + "')";

Working fine but in datagrid have values

09.05.2018 00:00:00

09:51:32.25655565

In sql value is 2018-05-09

09:51:32.25655565

I need

09.05.2018

09:51:32

Some help?

2 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

Nitin Sontakke8y ago
Accepted answer
Also any specific business reason why you are storing date and time separately? Please store them together.
Nitin Sontakke8y ago
I believe I have mentioned this several times before on serveral threads. The date and time stored in database is for the computer consumption. DO NOT LOOK AT IT. In whatever format you want it to show to the user, format it in front-end or any other layer. DO NOT interfere with database layer. Date in database SHOULD BE in yyyy-MM-dd HH:mm:ss format ONLY.

Please do let me know if you still have any questions.