How would I extract the 'time' from a datetime SQL field .. I can not
change it to a string because dtoc() chops off the time ??
Thanks
Rick Lipkin
On Jun 16, 10:28 am, Rick Lipkin <lipkinrm29...@yahoo.com> wrote:
>
> How would I extract the 'time' from a datetime
> SQL field .. I can not change it to a string
> because dtoc() chops off the time ??
Looks like TtoC() will return a system-formatted DateTime string (with
caveats).
Looks like TtoS() will return a DateTime string, with the system time
starting at byte number 9, 9+10 - hour, 11+12 = minute, balance =
seconds (including decimal portion if any).
From the online docs...
David A. Smith
David
Sorry for the dumb reply .. what LIb do I need to link ?? I am already
linking in Ct.lib ??
Rick
David
I got it .. thanks .. I can work with Ttoc() ..
Rick
You could also use the CONVERT or CAST SQL functions to extract just
the date from a timestamp field.
Reinaldo.