I have a start date and an end date . I need to find out the date difference ( the duration )
I’m used the datediff function and got the difference in sec.
Can anyone tell how can I convert total number of sec onto “mm/dd/yyyy” format.
I used Date (sec) but it gives me wrong date.
I’m using CR 10 and SQL server 2005.
Thanks in advance
I’m used the datediff function and got the difference in sec.
Can anyone tell how can I convert total number of sec onto “mm/dd/yyyy” format.
I used Date (sec) but it gives me wrong date.
I’m using CR 10 and SQL server 2005.
Thanks in advance