hi,
I have the below columns in a SQL table
date_created | Code
--------------------------------------------------------------------------------
2008-02-21 09:24:03.000 | 128480882430993750
2008-02-21 13:03:36.000 | NULL
2008-02-22 10:23:46.000 | 128481782253806250
---------------------------------------------------------------------
the code is nothing but the date_created.ToFileTime() of .Net. At present i have a requirement to search the missed code and needs to update. I can loop thru each missed code record and update from .Net.But records are more so think to update in SQL itself. But i cant find out a method in SQL to convert the date time to file format (i.e 128480882430993750). Please help me on this.
Thanks and regards
...
Go to the complete details ...