Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

Re: Placeholder Error (Placeholder :0 invalid, placeholders must be >= 1)

by PeterPeiGuo (Hermit)
on Jan 14, 2011 at 01:47 UTC ( [id://882272] : note . print w/replies, xml ) Need Help??


in reply to Placeholder Error (Placeholder :0 invalid, placeholders must be >= 1)

If the only reason to select that date back is to use it later in the insert statement, then you really don't need to do that. If the type of FT_DATE column is Date, you can simply use to_date in the values clause of that insert statement.

Peter (Guo) Pei

  • Comment on Re: Placeholder Error (Placeholder :0 invalid, placeholders must be >= 1)