Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-14 : 19:12:46
|
Edmund writes "
Hi,
I have declared 2 fields(starttime and endtime) in my schedule table as datetime format under SQL server(Japanese version).
Basically i just need get the time in original format(Japanese version,eg. PM 1:00(assume the PM is in japanese character)but what I got after retrieve the data was in 24 hour format(eg PM 1:00 become 13:00).I am not sure whether it is a system related setting or sql setting.The data in SQL server are correct, meaning they are stored in japanese version with 12 hour format.Any idea why it has been converted to 24 hour format before i do any date formating function?
Another question is what is the best method to compare time.
For example if i want to compare let say,
if time is 3:00 pm then
...
end if
FYI, i am using ASP and ADO to link to the database.Thanks in advance for your help." |
|
|
|
|
|
Time changed to 24 hour format,why??