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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
convert 1.27e+017 to time/date
- Thread starter cardimom
- Start date
synapsevampire
Programmer
Probably, but this would be Crystal version and database dependent, and what level of precision you expect.
What you're seeing is Crystal's version of scientific notation.
It's odd that anyone would store a backup time at such precision, suspicious...
The best way to resolve this is to first learn how it is stored in the database, and then convert it on the database side either in a View/SP, or using a SQL Expression in Crystal.
-k
What you're seeing is Crystal's version of scientific notation.
It's odd that anyone would store a backup time at such precision, suspicious...
The best way to resolve this is to first learn how it is stored in the database, and then convert it on the database side either in a View/SP, or using a SQL Expression in Crystal.
-k
- Status
Similar threads
- Locked
- Question