DateTime problem

[Bug]

I am working with an existing SQL table. For reasons not known to me they have decided to store the date and time in two seperate cells. Date is in a smalldatetime cell and time is stored in a datetime field.

My problem is whether I can get just the hh:mm:ss AM/PM to be stored into this datetime field without the 1/1/1900 being included.
I am updating the SQL record. But when I assign my value to the SQL cell, even though the value only holds the hh:mm:ss AM/PM, it always includes the 1/1/1900 in front of it.

Is there anyway around this without modifying the design of this table?

Thanks

[patelaashish]

Hi,

Please try the following javascript for the column in which you need just the hh:mm:ss.

<%= Time() %>

Let me know.

Cheers,

Aash.

[Bug]

That was one of the ways I tried.
I even put a Resonse.Write after it to make sure what I was updating the SQL table with just had the hh:mm:ss: AM/PM in it.

ex.
<%
dtTime = Time()
Response.Write dtTime <---- came back with just "10:33:07 AM

But when the variable dtTime is used to update the cell defined as DateTime it has 1/1/1900 10:33:07 AM in it.

Thanks

[patelaashish]

Hi Bug,

The other short way is to convert the datatype to nvarchar and then use the javascript.

I have tried that and it works at my end.

Please let me know.

Thanks,

Aash.

[Bug]

Unfortunately that's what I had to do.
Everything works well on my end but we had to touch the other app that worked with this database.

No one was willing to tell me why this was set up this way to begin with :)

Thanks