Re: Converting Now date to Oracle's whacky date

ratnamadhuri — Fri, 14 Dec 2007 05:00:00 GMT

Date.Now.ToString("yyyy-MMM-dd")

doesnt make sense but works.

You can also try Date.Now.ToString("dd-MMM-yyyy")

universal function to convert any oracle date to .net date

to_char(doe,'MM-DD-YYYY HH24:MI:SS')= '" & doe.ToString("MM-dd-yyyy HH:mm:ss")

(doe is of type date)

The format of the second parameter for oracle date function should match the format of the parameter for the .net function.

example shown below

Public Sub updatedate(ByVal number As String, ByVal doe As Date, ByVal username As String)

Dim query As String

Try

query = "Update tablename set date1 ='" & Date.Now.ToString("yyyy-MMM-dd") & "',username= '" & DatabaseConnections.Username() & "' where id= " & number& " and user_id='" & username & "' and to_char(doe,'MM-DD-YYYY HH24:MI:SS')= '" & doe.ToString("MM-dd-yyyy HH:mm:ss") & "'"

Dim cmdupdate As New OleDbCommand(query, dbcon.opendatabaseconnection())

Dim i As Integer

i = cmdupdate.ExecuteNonQuery()

If (i > 0) Then MessageBox.Show("Task completed")

Catch ex As Exception

MessageBox.Show("Error in updatediarycompletedate() " & ex.Message)

Finally

dbcon.closeconnection()

End Try

End Sub

A call to the above function will be like

databaseconnectionsclassfileobject.updatedate(8000, datetime.now.date, username)

Search results matching tags 'Oracle' and 'time'

Re: Converting Now date to Oracle's whacky date