Dealign with time

[TheConeHead]

What is the best type of field to deal with time.... I just want time not date or anything else....

 

[donutman]

Datetime. The date will/should be 1/1/1900.
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[TheConeHead]

ok here is a problem... I have used datetime... I have hardcoded in a time of 9:00:00 AM and in an asp I have a conditional statement:

if (String(field) == "9:00:00 AM") {

but it is not executing this condition as if they are not the same... is something being doen that I can not see? When I repsponse.write the field it come up 9:00:00 AM

?????

 

[ks2000]

SmallDatetime,

Good Luck
Gopala Krishna Kakani

 

[ks2000]

That time string should be like this 1900-01-01 9:00:00.000




Good Luck
Gopala Krishna Kakani