>>DTOS return a 8 char string for both Date and Datetime fields
>>
>>There doesn't seem to be a TTOS???
>>
>>How do you get a string from datatime that includes the time?
>>
>>( I really should know this but it has been a long time and a long day)
>>
>>TIA
>
>Look at TTOC with second parameter 1.
Thank you. I think I knew that before I got old <g>
A second parameter of 3 seems best for creating a string that works in an insert statement in SQL
'2009-03-13T16:29:59'
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.