[SQL] error: cast the timestam expression

2005-01-28 Thread friendVU admin
When I execute this: insert into comments ( date_posted ) (select date_published from xyz ) I get : ERROR: column date_posted is of type timestamp without time zone but expression is of type text HINT: You will need to rewrite or cast the expression. Both dates are of

Re: [SQL] error: cast the timestam expression

2005-01-28 Thread Michael Glaesemann
On Jan 28, 2005, at 23:55, friendVU admin wrote: When I execute this: insert into comments ( date_posted ) (select date_published from xyz ) I get : ERROR: column date_posted is of type timestamp without time zone but expression is of type text HINT: You will need to

Re: [SQL] error: cast the timestam expression

2005-01-28 Thread Tom Lane
friendVU admin [EMAIL PROTECTED] writes: When I execute this: insert into comments ( date_posted ) (select date_published from xyz ) I get : ERROR: column date_posted is of type timestamp without time zone but expression is of type text HINT: You