Ola, to_char(data,'DD-MM-YYYY')
[]s 2008/6/19 Leandro DUTRA <[EMAIL PROTECTED]>: > 2008/6/19 Newton Teixeira do Nascimento Júnior <[EMAIL PROTECTED] > >: > > O Jota indicou a seguinte solução: select data from tabela where > > to_char(data,'DD/MM/YYYY')='19-06-2008'; > > > > Pergunta: Como fazer a data (no formato timestamp with time zone) > > "2008-06-19 16:32:18-03" se transformar em "19-06-2008" ??? > > Mude a máscara da TO_CHAR (). > > -- > skype:leandro.gfc.dutra?chat Yahoo!: ymsgr:sendIM?lgcdutra > +55 (11) 3040 7300 r155 gTalk: xmpp:[EMAIL PROTECTED]<[EMAIL PROTECTED]> > +55 (11) 9406 7191 ICQ/AIM: aim:GoIM?screenname=61287803 > +55 (11) 5685 2219 MSN: msnim:[EMAIL PROTECTED] > _______________________________________________ > pgbr-geral mailing list > [email protected] > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > -- João Paulo www.dextra.com.br/postgres PostgreSQL
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
