Hi,

I just had problem with Date Time conversion. Here is the example:

Select GetDate()

Result: 2000-08-02 23:50:15.280

Then I use Convert function:

Select Convert(DateTime,Cast(GetDate() as varchar), 101)

Result: 2000-08-02 23:50:00.000

What I expected to see is: 08/02/2000 and it was what I used to get.


Can anybody helpe to solve this problem? I am running sql server 7.0



Thanks,


Jim