Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Format DateTime Fractional Seconds
Here is the SELECT Statement from Crystal.. SELECT ProcessData.Value, Item.Name, ProcessData.EventTime FROM dbo.Item Item, dbo.ProcessData ProcessData WHERE Item.ID=ProcessData.ItemID AND Item.Name='FV.Pressure' One of the EventTimes that I get back looks like this... 11/21/2003...- mklikes
- Post #5
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Format DateTime Fractional Seconds
The native database is based on Objectivity (an object oriented database), as a result I can only read the data. Therefore I must do any transforming of the data in Crystal. As stated the native format is 'mm/dd/yy hh:mm:ss.sss' and I am trying to keep it in this format within Crystal. Can this...- mklikes
- Post #3
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Format DateTime Fractional Seconds
I am using Crystal Reports 9 and a thirdy party ODBC Datasource. This datasource has a datetime field that has time precision to 1/1000 of a second (displayed as mm/dd/yy hh:mm:ss.sss). When I bring this data into Crystal, it rounds to the nearest second (mm/dd/yy hh:mm:ss). For my reporting I...- mklikes
- Thread
- Replies: 4
- Forum: Business Objects: Crystal Reports 2 Data Access
