Datetime issues here

[Sammy145]

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

 

[Sammy145]

I got the solutions

1.

http://www.kiranreddys.com/crystal_faqs/02290806.html#02291045

 

[synapsevampire]

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

 

[synapsevampire]

Sammy: That's the long way home, check my FAQ.

-k