I retrieve a cursor from SQL Server database using SQLEXEC. One of the fields in the table is smalldatetime. I would like to convert it to Date type so that my UI does not show the time portion. I tried to use DbSetProp() function but it requires a database.
Is there a way to convert this column on-the-fly while retrieving from SQL Server? Or should I use ALTER TABLE to change the column type?
Thank you in advance for any suggestions.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham