Re: date_part, how to use
От | Christopher Kings-Lynne |
---|---|
Тема | Re: date_part, how to use |
Дата | |
Msg-id | GNELIHDDFBOCMGBFGEFOKEJNCCAA.chriskl@familyhealth.com.au обсуждение исходный текст |
Ответ на | Re: date_part, how to use ("Joel Burton" <joel@joelburton.com>) |
Список | pgsql-sql |
Hmmm...don't know actually now that you mention it! Chris > -----Original Message----- > From: pgsql-sql-owner@postgresql.org > [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Joel Burton > Sent: Wednesday, 15 May 2002 11:24 AM > To: Christopher Kings-Lynne; juerg.rietmann@pup.ch; > pgsql-sql@postgresql.org > Subject: Re: [SQL] date_part, how to use > > > I'll bite. Why better? > > Joel BURTON | joel@joelburton.com | joelburton.com | aim: wjoelburton > Knowledge Management & Technology Consultant > > > -----Original Message----- > > From: Christopher Kings-Lynne [mailto:chriskl@familyhealth.com.au] > > Sent: Tuesday, May 14, 2002 10:08 PM > > To: Joel Burton; juerg.rietmann@pup.ch; pgsql-sql@postgresql.org > > Subject: RE: [SQL] date_part, how to use > > > > > > SELECT EXTRACT (DATE FROM tpl_start_timestamp) is better > > > > Chris > > > > > -----Original Message----- > > > From: pgsql-sql-owner@postgresql.org > > > [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Joel Burton > > > Sent: Tuesday, 14 May 2002 8:27 PM > > > To: juerg.rietmann@pup.ch; pgsql-sql@postgresql.org > > > Subject: Re: [SQL] date_part, how to use > > > > > > > > > Will > > > > > > SELECT CAST( tpl_start_timestamp AS date ) > > > > > > work? > > > > > > Sigh. CFML is so ugly. Anyway, hope this helps. > > > > > > > > > Joel BURTON | joel@joelburton.com | joelburton.com | aim: wjoelburton > > > Knowledge Management & Technology Consultant > > > > > > > -----Original Message----- > > > > From: pgsql-sql-owner@postgresql.org > > > > [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of > > > > juerg.rietmann@pup.ch > > > > Sent: Tuesday, May 14, 2002 5:29 AM > > > > To: pgsql-sql@postgresql.org > > > > Subject: [SQL] date_part, how to use > > > > > > > > > > > > Hello there > > > > > > > > How can I extract the date part from a timestamp ? Thanks for > > any help ! > > > > > > > > select * from transport_log > > > > where > > > > tpl_status != '0' and > > > > tpl_zylinder LIKE <cfif '#session.filter_zid#' EQ ''> '%' <cfelse> ' > > > > #session.filter_zid#%' </cfif> and > > > > datepart('dd.mm.yyyy',tpl_start_timestamp) > <cfif ' > > > > #session.filter_FromDate#' EQ ''> '01.01.1900' <cfelse> ' > > > > #session.filter_FromDate#' </cfif> > > > > order by tpl_transport > > > > > > > > > > > > Regards ... jr > > > > > > > > __________________________________________________ > > > > > > > > PFISTER + PARTNER, SYSTEM - ENGINEERING AG > > > > Juerg Rietmann > > > > Grundstrasse 22a > > > > 6343 Rotkreuz > > > > Switzerland > > > > > > > > internet : www.pup.ch > > > > phone : +4141 790 4040 > > > > fax : +4141 790 2545 > > > > mobile : +4179 211 0315 > > > > __________________________________________________ > > > > > > > > > > > > > > > > ---------------------------(end of > > broadcast)--------------------------- > > > > TIP 4: Don't 'kill -9' the postmaster > > > > > > > > > > ---------------------------(end of > broadcast)--------------------------- > > > TIP 5: Have you checked our extensive FAQ? > > > > > > http://www.postgresql.org/users-lounge/docs/faq.html > > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html >
В списке pgsql-sql по дате отправления: