ADO Date time update SQL Server

[Rick Lipkin]

To All

How can I convert date() to a datetime field in MS Sql server .. I was given this formula and it does work but does not insert the correct
date into the date portion of the field ..

nDateTime := ( DATE() - CTOD("") )+( SECONDS()/ (24*3600)) equals
something like 6/19/8620 5:17:14 PM

As you can see .. todays date is 05/22/2008 5:17 PM ..

I have records sorted by date desc and SQL server does not take into account natural order .. when you insert DATE() into a datetime field you get 5/22/2008 12:00 PM .. and if you have two rows with the same date .. I can not descriminate the time since both have the same 'default' time.. I need to be able to insert the date and time into the datetime fields to make the rows sort correctly.

Any advice or help would be appreciated BIG-TIME !!

Rick Lipkin
SC Dept of Health, USA

[sysctrl2]

Rick,

esto es un error grave de xharbour ,

ADO solamente devuelve la FECHA

dejando fuera la hora,

este tema ya se habia mensionado en mensajes anteriores,

pero nadie ha dado una solucion,

saludos..

[Rick Lipkin]

Rick,

this is a serious error of xharbour,
ADO only returns the DATE
leaving was the hour,
this theme already itself habia mensionado in previous messages,
but nobody has given a solucion,

Greetings..

I seem to have run into that 'brick wall' .. will do some more searching ..

Thanks
Rick Lipkin

[Eugeniusz Owsiak]

Rick,

Code: Select all  Expand view

set date american
set century on
...

oRs:Source := "Update <your table> set <your datetime field> = '"+;
dtoc(date())+" "+time()+"' where ......"
...
oRs:Open()


This update work for me and i get a proper datetime value in table.
Maby I don't understand your problem. If so - sorry.

Regards Eugeniusz

[Rick Lipkin]

Eugeniusz Owsiak

* dtoc(date())+" "+time() * .. WOW, that worked !!!!!!!!!!!!! beating my head against the wall here over something so simple.

Glad you had a better pair of eyes than I did ..

Thanks for the HELP !!

Rick Lipkin

[nageswaragunupudi]

If you are using xHarbour, you can straighaway use datetime.

dtDate := DateTime()
oRs:Field(x):Value := dtDate

Now xHarbour can handle date and time together, it is no more necesssary for us to handle date and time separately