Hi,
I have a table in the SQL Server (which is update from an iOS application). The field Date_Time is using type Datetime2
I am creating a report that shows this column. When I see the column in the cursor (created with SQL Select), the cursor correctly shows the date time. But when I display it in the report, it shows only Date. How do I show the value (in the report) as a Date and Time (readable by a user)?
UPDATE. Easily resolved with CAST() function.
"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