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 'YYYYMMDDHHMMSS' as a text string. Do I have to convert > this to the format shown in the Postgres manual: '1999-01-08 04:05:06' for > Postgres to accept the value or can I just pass an integer as > 19990108040506 for the timestamp?
You need to pass it a valid timestamp, either in ISO format as you show, or European/US/... standards (depending on your settings). There's a full list of formats in the data-types section of the manuals. -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly