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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Datetime issues here

Status
Not open for further replies.

Sammy145

Programmer
Oct 4, 2002
173
GB
I am Running crystal reports ver 11

1.the first issue is how do I convert seconds to format hh:mm:ss accurately

2. I have a stored procedure that takes in dateformat as
'Jun 20 2005 12:00:00.000PM'
how do i tell the paramters to look up results using this datetime format or do I need to convert the datetime in my stored procedure

Thank you
 
1) Check my FAQ: faq767-3543

2) What's the question? If you pass a datetime to an SP, the SP should use that data type. Are you asking for programming help within the SP? If so, at least include your database type. Crystal doesn't have any control over parameters created in Stored Procedures, so if you want to just use a date type (again, it depends upon your database), then use a date type in the SP and convert it and then go against the datetime type within the SP.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top