convert from an integer to a date
От | STashlitsky@JEFCO.com |
---|---|
Тема | convert from an integer to a date |
Дата | |
Msg-id | OFC94B0A45.89F8C8AE-ON85256CCD.0075A6DD@jc.jefco.com обсуждение исходный текст |
Ответы |
Re: convert from an integer to a date
|
Список | pgsql-sql |
<br /><font face="sans-serif" size="2">When I run </font><font color="blue" face="MS Sans Serif" size="1">select</font><fontface="MS Sans Serif" size="1"> to_date('20030212','YYYYMMDD') the output is 2/12/03</font><br/><font face="MS Sans Serif" size="1">if I run </font><font color="blue" face="MS Sans Serif" size="1">select</font><fontface="MS Sans Serif" size="1"> to_date( to_char(20030212,99999999),'YYYYMMDD'); the output is6/23/05</font><br /><br /><font face="MS Sans Serif" size="1">How can I convert from integer into date format correctly?</font><br/><br /><font face="MS Sans Serif" size="1">Thanks for any help with this.</font><br /><br /><font face="MSSans Serif" size="1">Svetlana</font><br /><br /><font color="#000000" face="Helv" size="3"></font><br /><font color="#000000"face="Helv" size="3"></font><br /><font color="#000000" face="Helv" size="3"></font><br /><font color="#000000"face="Helv" size="3">Jefferies archives and reviews outgoing and incoming e-mail. It may be produced at therequest of regulators or in connection with civil litigation. Jefferies accepts no liability for any errors or omissionsarising as a result of transmission. Use by other than intended recipients is prohibited.</font><br />
В списке pgsql-sql по дате отправления: