Converting SQL timestamp to DB2,,,anyone with any

[jcash35010]

suggestions? I have the timestamp from SQL which I need to convert to enter into DB2 format timestamp. Does anyone know how to do this? I've tried several different things, and so far nothing works...

any help is greatly appreciated!

 

[DotNetDoc]

I am not sure what DB2 Time stamp format is but we had to do the same thing using mySQL so we just created a functions class which among other things converted the date into the format required by mySQL
See below.

Public Class Functions




Public Function DateChange(ByVal intDate) As String





Dim intDay As String
Dim intMonth As String
Dim intYear As String

intDay = Day(intDate)
intMonth = Month(intDate)
intYear = Year(intDate)

'Get the day : parse method

Dim MyLen As Integer
MyLen = Len(intDay)
If MyLen = 1 Then intDay = "0" & intDay

'Get the month : parse method
MyLen = Len(intMonth)
If MyLen = 1 Then intMonth = "0" & intMonth

Dim dDate As String
dDate = (intYear & intMonth & intDay)

Return dDate



End Function



End Class

DotNetDoc
M.C.S.D.
---------------------------------------

Tell me and I forget. Show me and I remember. Involve me and I understand.
- Anonymous Chinese Proverb

-----------------------------------

If you can't explain it simply, you don't understand it well enough.
- A. Einstein