am or pm in time ?

[Joe Van Meer]

HI all,

In my sql query for my app how do I determine if the datetime value in the
database is am or pm?

Cheers & thanks, Joe

 

[Kevin Spencer]

What kind of database are we talking about?

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Ambiguity has a certain quality to it.

 

[Joe Van Meer]

Hi again,

Sry, it is sql server 2000 and I am storing a value like : 1/2/2005 1:03:00
AM.

I did not locate the argument for the datepart function for am or pm.

Cheers, Joe

 

[Joe Van Meer]

I guess what I am really getting at is how to compare 2 datetime values in
the above format to the minute.

Cheers, Joe

 

[Guest]

Maybe Date.Parse("1/2/2005 1:03:00 am") does the trick ?
--
Rainier van Slingerlandt
www.slingerlandt.com

Please hit the Yes button If my effort is helpfull.

 

[Kevin Spencer]

The DATEPART function, when used with hours, will return a number between 0
and 23.

It is important to remember that what you see is a formatted date, but what
the database sees is a number. Humans like to see things in different ways,
but in truth and in fact, there are 24 hours in a day, and the hour part of
a date will therefore always be a number between 0 and 23.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Ambiguity has a certain quality to it.

 

[Joe Van Meer]

Thanks gentlemen! Totally forgot about that Kevin, thx for reminder.

Cheers, Joe