Insert with data via PHP.

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc
  

Poston Tue, 02 Jan 2007 8:38 am

Guys I have an insert made by a PHP script, it worked fine, but now I need to insert a date field invalid format on the date, accuses do it like this:
Code: Select all
insert into tabela (campo_data) (to_date('variavel_data', 'DD/MM/YYY'))
the contents of variable data is a string like this: dd/mm/yyyy. Does anyone have any tips?
pyro
Location: Barala - TT

Poston Tue, 02 Jan 2007 8:56 am

Looks like it's missing a Y in YYYY. (only 3)
dr_gori
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?
http://glufke.net/oracle/search.php?search_id=unanswered

Poston Tue, 02 Jan 2007 11:25 am

Dude, thanks but this error was typing when I typed here.
In my script all right. Mysteriously the business began operating.
I don't understand so far.
pyro
Location: Barala - TT

Poston Tue, 02 Jan 2007 1:38 pm

MYSTERY ...
And some people say that computers is an EXACT SCIENCE:-D
dr_gori
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?
http://glufke.net/oracle/search.php?search_id=unanswered



Return to SQL

Who is online

Users browsing this forum: Google [Bot] and 4 guests