Adrian Klaver wrote:
> test=# select to_timestamp('02/26/2011 14:50', 'MM/DD/YYYY HH24MI');          
>                                                                               
>                        
>       to_timestamp                                                            
>                                                                               
>                        
> ------------------------                                                      
>                                                                               
>                        
>  2011-02-26 14:00:00-08                                                       
>                                                                               
>                        
> (1 row)                                                                       
>                                                                               
>                        
> 
> Corrected for the ':':                                                        
>                                                                               
>                                              
> 
> test=# select to_timestamp('02/26/2011 14:50', 'MM/DD/YYYY HH24:MI');         
>                                                                               
>                        
>       to_timestamp                                                            
>                                                                               
>                        
> ------------------------                                                      
>                                                                               
>                        
>  2011-02-26 14:50:00-08                                                       
>                                                                               
>                        
> (1 row)                                   
> 
> 
> On 9.0.3 corrected for the ':':
> 
> test(5432)aklaver=>select to_timestamp('02/26/2011 14:50', 'MM/DD/YYYY 
> HH24:MI');
>       to_timestamp      
> ------------------------
>  2011-02-26 14:50:00-08
> (1 row)
> 
> 
> Seems 9.0+ is stricter on its parsing.

Agreed.  We have made some cleanups to the to_timestamp code in recent
major releases and that is what the user must be seeing.

-- 
  Bruce Momjian  <br...@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to