is there a way to get hh:mm:ss given seconds - Mailing list pgsql-sql
| From | Narendra A |
|---|---|
| Subject | is there a way to get hh:mm:ss given seconds |
| Date | |
| Msg-id | 001f01c2268b$c81ae2b0$19ba10ac@narendraa Whole thread Raw |
| Responses |
Re: is there a way to get hh:mm:ss given seconds
(David Stanaway <david@stanaway.net>)
Re: is there a way to get hh:mm:ss given seconds (Tod McQuillin <devin@spamcop.net>) |
| List | pgsql-sql |
<div class="Section1"><p class="MsoNormal"><span class="EmailStyle15"><font color="black" face="Arial" size="2"><span style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial">Sir,</span></font></span><p class="MsoNormal"><span class="EmailStyle15"><font color="black" face="Arial" size="2"><spanstyle="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial">Is there a way in sql such that if I give seconds it should me return me hours:mins:seconds</span></font></span><pclass="MsoNormal"><span class="EmailStyle15"><font color="black" face="Arial" size="2"><spanstyle="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial"> </span></font></span><p class="MsoNormal"><span class="EmailStyle15"><font color="black" face="Arial" size="2"><spanstyle="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial">Eg. Seconds<span style="mso-tab-count:1"> </span>hh:mm:ss</span></font></span><p class="MsoNormal" style="margin-left:1.0in;text-indent:-.5in;mso-list:l0level1 lfo1; tab-stops:list 1.0in"><span class="EmailStyle15"><font color="black" face="Arial" size="2"><span style="font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial">422<font face="Times New Roman" size="1"><span style="font:7.0pt "Times New Roman""> </span></font></span></font></span><span class="EmailStyle15"><font color="black" face="Arial" size="2"><spanstyle="font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial">1:01:02</span></font></span><p class="MsoNormal"><span class="EmailStyle15"><font color="black"face="Arial" size="2"><span style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial"> </span></font></span><p class="MsoNormal"><span class="EmailStyle15"><font color="black" face="Arial" size="2"><spanstyle="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial">eagerly waiting for response.</span></font></span><p class="MsoNormal"><span class="EmailStyle15"><font color="black"face="Arial" size="2"><span style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial"> </span></font></span><p class="MsoNormal"><span class="EmailStyle15"><font color="black" face="Arial" size="2"><spanstyle="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial">Regards</span></font></span><p class="MsoNormal"><span class="EmailStyle15"><font color="black" face="Arial" size="2"><spanstyle="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial">Narendra</span></font></span></div><br /> DISCLAIMER: This email is bound by the terms and conditions described at<br /> http://www.subexgroup.com/mail-disclaimer.htm<br />