Dear Mr.Rao,
I am yet to learn many existing functions in xHarbour and FiveWin. I was not aware of the function DateTime() and TtoC( tDate, 2 )
I feel dealing with date and time values separately have become things of past. Now datetime variables can be used directly.
In my MS-Sql database I am using DateTime type column and I extracted the Time part from it as a seperate column in the recordset using the following Sql
- Code: Select all Expand view
SELECT Branch_Short_Name, Last_Upload, CONVERT(varchar(10), Last_Upload, 108) as UploadTime FROM Branches
If knew the functions DateTime() and TtoC(), then I would have extracted the Date and Time separately from a DateTime column using FiveWin itself.
I need the Time part separately for some reporting purpose.
The following command would serve my purpose
- Code: Select all Expand view
cValToStr( tDate, 'DD-MMM-YYYY' ) + ' ' + TToC( tDate, 2 )
Using the AMPM() with the above functions, I don't have to use the SET TIME FORMAT TO command
Once again I thank you for the support.
Regards
Anser