Version: Crystal Reports XI
I used the formula:
DateTimeValue({table.field})
returns
2007-03-14 12:00:00AM
I need it to return 2007-03-14 15:59:14 instead
I am trying to return both the date and time from a timestamp field in a crystal report from sql database.
Timestamp is datetime variable in sql which show 2007-03-14 15:59:14.263 in sql, but only the date returns in crystal reports.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.