Adi wrote:
> I'm sorry, but I don't understand what you want. Can you show me the
> output that want to get from the number 12345?
>
> Adi
>
> vishwadh wrote:
> > Actually i want to display this int or you can say seconds into time
> > format only.
> >
> >
> >
> > Adi wrote:
> >
> > > As far as I know converting int to datetime will only show you the
> > > date part and the hour will always be set to midnight. Maybe you are
> > > looking for dateadd function that lets you add 12345 seconds to a
> > > certain date?
> > >
> > > Adi
> > >
> > > vishwadh@gmail.com wrote:
> > > > hi
> > > >
> > > > I want to know, how will we convert int to time.let me show u by
> > > > example.
> > > > if i have int i=12435 then it will convert into hours,minutes and
> > > > seconds.....
> > > > let this i will be in seconds.so how can i convert this?is there any in
> > > > built function to convert this int(seconds) into time.
> > > >
> > > > thanks in advance

Aaron Bertrand [SQL Server MVP] wrote:

> If you are starting with a number of seconds see
> http://www.aspfaq.com/2271
>
>
>
>
>
> <vishwadh@gmail.com> wrote in message
> news:1153117039.633992.249700@i42g2000cwa.googlegroups.com...
> > hi
> >
> > I want to know, how will we convert int to time.let me show u by
> > example.
> > if i have int i=12435 then it will convert into hours,minutes and
> > seconds.....
> > let this i will be in seconds.so how can i convert this?is there any in
> > built function to convert this int(seconds) into time.
> >
> > thanks in advance
> >