how to use the TO_DATE Function for more date inputs.

Rajesh B

i have writing a query to connect oracle db with asp.net, and i have created a webpage and then i kept 3 textboxes, and two buttons for getting input and o/p, in textboxes i have to give the date and in oracle db i have created column for those dates, am using to_date function, but i dont know how to write the to_date for continuesly, its says some syntax error. so can you please tell me how to use the to_date function for continuesly and next to some uppended textboxes, i ll mention the code below for ur reference.

string oocdate = txtoocaccpteddate.Text;
string filingdate = txtfillingdate.Text;
string fieldautorities = txtfieldwithauth.Text;
string receipt = txtreceiptdate.Text;
string approved = txtapproveddate.Text;
string appvalidfrom = txtapplicationvalidfrom.Text;
string appvalidto = txtapplicationvalidto.Text;

string sql = "insert into tmp (REC_KEY, APPL_NO, EMP_NO, CASE_VISA_TYPE_CODE, CASE_VISA_SUBTYPE_CODE, OOC_ACCEPTED_DATE, FILING_SENT_DATE, FILED_WITH_AUTHORITIES, RECEIPT_DATE, APPROVED_DATE, APPL_VALID_FROM, APPL_VALID_TO) values ('" + txtreckey.Text + "','" + txtrefappno.Text + "','" + txtempid.Text + "','" + txtcasevisatype.Text + "','" + txtcasevisatypecode.Text + "','(TO_DATE('" + oocdate + "','DD-MM-YY HH:MI A.M.'))','(TO_DATE('" + filingdate + "','DD-MM-YY HH:MI A.M.'))','(TO_DATE('" + fieldautorities + "','DD-MM-YY HH:MI A.M.'))','" + txtreceiptno.Text + "','(TO_DATE('" + receipt + "','DD-MM-YY HH:MI A.M.'))','(TO_DATE('" + approved + "','DD-MM-YY HH:MI A.M.'))','(TO_DATE('" + appvalidfrom + "','DD-MM-YY HH:MI A.M.'))','(TO_DATE('" + appvalidto + "','DD-MM-YY HH:MI A.M.'))";

// here i have diclared the textboxes as some var name and i have appending them in to_date functions. here first two columns are varchar type, like rec_key and emp id, case visa type, case visa subtype, these things are varchar and other than this everything is date. i dont knnow the syntax for continuesly using to_date function.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajesh B13y ago
actually i wants to 30 columns in a table in that i have around date columns and above 20 varchar and number columns in oracle db, for that am using like above coding , i can fetch the data(select) into textboxes and i needs edit the selected data and again i have to insert the new data entered into db.for that am using this to_date function, i dont know the sysntax to write for the to_date function in asp.net c# query for inserting continuesly 2 date columns and after varchar textbox appended column TO_date function,
Iftikar Hussain13y ago
you like to append two textbox data and insert into datecolumn?

Regards,
Iftikar
Rajesh B13y ago
hi Iftikar Hussain, thanks for your answer, but my doubt is how to use that to_date functions for continuelsy two textboxes and appended textboxes syntax for example,insert into tmp(rec_key,empno,approved date) values('"+txtreckey.Text+"','"+emp id.text+"',(to_date('"+approveddate.Text+"','DD-mm-yy)','(to_date(someother date column)); is this right or something other format is there?
Iftikar Hussain13y ago
Hi,
Try like this

string sql = "insert into tmp (REC_KEY, APPL_NO, EMP_NO, CASE_VISA_TYPE_CODE, CASE_VISA_SUBTYPE_CODE, OOC_ACCEPTED_DATE, FILING_SENT_DATE, FILED_WITH_AUTHORITIES, RECEIPT_DATE, APPROVED_DATE, APPL_VALID_FROM, APPL_VALID_TO) values ('" + txtreckey.Text + "','" + txtrefappno.Text + "','" + txtempid.Text + "','" + txtcasevisatype.Text + "','" + txtcasevisatypecode.Text + "','TO_DATE('" + oocdate + "','DD-MM-YY HH:MI A.M.')','TO_DATE('" + filingdate + "','DD-MM-YY HH:MI A.M.')','TO_DATE('" + fieldautorities + "','DD-MM-YY HH:MI A.M.')','" + txtreceiptno.Text + "','TO_DATE('" + receipt + "','DD-MM-YY HH:MI A.M.')','TO_DATE('" + approved + "','DD-MM-YY HH:MI A.M.')','TO_DATE('" + appvalidfrom + "','DD-MM-YY HH:MI A.M.')','TO_DATE('" + appvalidto + "','DD-MM-YY HH:MI A.M.'))";

if you are not passing time then use
TO_DATE('" + oocdate + "','DD-MM-YY')

Regards,
Iftikar