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!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DateTime field in Crystal against Oracle and SQL DB

Status
Not open for further replies.
020268

020268

Programmer
Apr 2, 2002
1
CA
Hi everybody!
Please help me to solve the problem:
We use to have separate reports for Oracle and SQL DB. Now I created Crystal reports, using Stored Procedures against Oracle DB wich works also with SQL DB.The problem is with DateTime in SQL and Date in Oracle.I need to display time in my report, and from Oracle I get always 12:00:00 AM.( even if I have real time in table).
Thanks for advices.
 
Status
Not open for further replies.

Similar threads

Kennymc
  • Locked
  • Question
Crystal connection to Microsoft business central 365
Replies
0
Views
847
Kennymc
Kennymc
s_reddibathuni
  • Locked
  • Question
export multiline address field from crystal to excel
Replies
3
Views
671
hilfy
hilfy
Insulations504
  • Locked
  • Question
Crystal Reports duplicating invoices
Replies
1
Views
589
dgillz
dgillz
Ivan Kok
  • Locked
  • Question
Crystal Reports Runtime causing AS/400 DB2 Database ID to be disabled intermittently
Replies
0
Views
559
Ivan Kok
Ivan Kok
BTPJayW
  • Locked
  • Question
Verify Database Not Working Against Stored Procedure
Replies
1
Views
625
hilfy
hilfy

Part and Inventory Search

Sponsor

Back
Top