Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parameter type DATE not DATETIME
Message
From
13/02/2003 16:09:31
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Crystal Reports
Title:
Parameter type DATE not DATETIME
Miscellaneous
Thread ID:
00752895
Message ID:
00752895
Views:
52
I have a report with "Date" not "DateTime" parameter.

I need to call it from Sql-Server store procedure. How can I convert DateTime into Time?

In VFP "Dtot(Date())" works well

In Sql-Server i used "Cast(Cast(GetDate() As Int) As DateTime)" but it doesn't work.

TIA
Next
Reply
Map
View

Click here to load this message in the networking platform