Re: [GENERAL] Newbie timestamp question

2004-03-17 Thread Robin 'Sparky' Kopetzky
Thank you for all your help. I built two simple functions (extract_timestamp, build_timestamp) to tear apart a timestamp and put it back together to make the job easier. Thanks again! 'Sparky' ---(end of broadcast)--- TIP 8: explain analyze is

Re: [GENERAL] Newbie timestamp question

2004-03-17 Thread Bruno Wolff III
On Wed, Mar 17, 2004 at 11:52:19 -0700, Robin 'Sparky' Kopetzky <[EMAIL PROTECTED]> wrote: > Good Morning!! > > I'm repairing a series of scripts in PHP that use the 'datetime' of MySQL > and converting them to Postgres. Question is this: The datetime format used > in the script is 'MM

Re: [GENERAL] Newbie timestamp question

2004-03-17 Thread Richard Huxton
On Wednesday 17 March 2004 18:52, Robin 'Sparky' Kopetzky wrote: > Good Morning!! > > I'm repairing a series of scripts in PHP that use the 'datetime' of MySQL > and converting them to Postgres. Question is this: The datetime format used > in the script is 'MMDDHHMMSS' as a text string. D

Re: [GENERAL] Newbie timestamp question

2004-03-17 Thread scott.marlowe
On Wed, 17 Mar 2004, Robin 'Sparky' Kopetzky wrote: > Good Morning!! > > I'm repairing a series of scripts in PHP that use the 'datetime' of MySQL > and converting them to Postgres. Question is this: The datetime format used > in the script is 'MMDDHHMMSS' as a text string. Do I have to

[GENERAL] Newbie timestamp question

2004-03-17 Thread Robin 'Sparky' Kopetzky
Good Morning!! I'm repairing a series of scripts in PHP that use the 'datetime' of MySQL and converting them to Postgres. Question is this: The datetime format used in the script is 'MMDDHHMMSS' as a text string. Do I have to convert this to the format shown in the Postgres manual: '19