Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 14 Jan 2008 @ 13:55:44 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Convert time from twenty four hour to twelve hour format
From:   Anomy Anom

<-- Anonymously Posted: Mon, 14 Jan 2008 07:44 -->

The FORMAT 'HH:MI:SSBT' should be correct. Are you certain the field is of type TIME? (Do SHOW TABLE to be certain.) What DBMS release?

Note also that VARCHAR(10) only allows enough space for the single letter A or P, not AM or PM.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020