am or pm time check in c# winform

Question

1.00/5 (1 vote)

See more:

hi there

i have some doubts which are

1-can i have only time field or date field in MS SQL SERVER 2005 ,,,all i see is datetime and there is no fromat to change ?

2- i have a time let say "02:23" how can i know that this tim is am or pm ???

stupid ones but mind is asking

thanx alot

Posted 20-Sep-13 15:44pm

eng.iris

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ZurdoDev · Answer 1 · 2013-09-20T16:22:00

SQL 2005 does not have a DATE format, only DateTime. I think it may be SQL 2012 that has a date format. However, what you'll store in the database is 0 for the day, which depending on your COLLATION may be 1/1/1900 and then store the time. The time is stored in 24 hour format so 1:00 PM is 13:00.

The displaying and formatting of the date and time is handled through your program but is stored as datetime in the db.

eng.iris · Answer 2 · 2013-09-20T17:17:00

Quote:
SQL 2005 does not have a DATE format, only DateTime. I think it may be SQL 2012 that has a date format. However, what you'll store in the database is 0 for the day, which depending on your COLLATION may be 1/1/1900 and then store the time

aha i got it

but the 2nd ques

Quote:
The time is stored in 24 hour format so 1:00 PM is 13:00.

the tim is not stored in pm or am
i want to write am and pm ?
how can i do that ?

am or pm time check in c# winform

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0