pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
save wiht time format
2+ messages / 2 participants
[nested] [flat]

* save wiht time format
@ 2005-02-25 23:11 enzo venegas palacios <enzovenegas@mixmail.com>
  2005-02-25 23:24 ` Re: save wiht time format Gavin M. Roy <gmr@ehpg.net>
  0 siblings, 1 reply; 2+ messages in thread

From: enzo venegas palacios @ 2005-02-25 23:11 UTC (permalink / raw)
  To: pgsql-php


does anyone know how to save a date in postgres where my_ table have 
format time.  or to change this format.
thanks,

enzo
---------------------------------------------------------
Abónate a la primitiva. Descubre la forma más fácil y cómoda de hacerse millonario. htp://sorteos.ya.com
ADSL + Llamadas 24 horas: desde 28,95 €/mes + IVA. Navega y habla de forma ilimitada. Sin compromiso de permanencia. http://acceso.ya.com/ADSLllamadas/




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: save wiht time format
  2005-02-25 23:11 save wiht time format enzo venegas palacios <enzovenegas@mixmail.com>
@ 2005-02-25 23:24 ` Gavin M. Roy <gmr@ehpg.net>
  0 siblings, 0 replies; 2+ messages in thread

From: Gavin M. Roy @ 2005-02-25 23:24 UTC (permalink / raw)
  To: enzovenegas@mixmail.com; +Cc: pgsql-php

If you use a timestamp field (or date field) you can format the output
using the to_char function.  The PgSQL docs have to_char very well
documented.

On Fri, 2005-02-25 at 18:11 -0500, enzo venegas palacios wrote:
> does anyone know how to save a date in postgres where my_ table have
> format time.  or to change this format.
> thanks,
> 
> enzo
> ---------------------------------------------------------
> Abnate a la primitiva. Descubre la forma ms fcil y cmoda de hacerse millonario. htp://sorteos.ya.com
> ADSL + Llamadas 24 horas: desde 28,95 /mes + IVA. Navega y habla de forma ilimitada. Sin compromiso de permanencia. http://acceso.ya.com/ADSLllamadas/
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-02-25 23:24 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-02-25 23:11 save wiht time format enzo venegas palacios <enzovenegas@mixmail.com>
2005-02-25 23:24 ` Gavin M. Roy <gmr@ehpg.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox