Groups > comp.lang.basic.visual.misc > #2230

Re: How To insert Date From VB6.0 to Oracle #2

From	tonisukmana <tonie_id@yahoo.com>
Subject	Re: How To insert Date From VB6.0 to Oracle #2
Newsgroups	comp.lang.basic.visual.misc
References	<1115223540.528401.47840@o13g2000cwo.googlegroups.com>
Message-ID	<oPudnaIWF7aX1CDJnZ2dnUU7-VWdnZ2d@giganews.com> (permalink)
Date	2015-01-19 12:12 -0600

Show all headers | View raw

how to format the date plus hours minutes seconds ? I got the error
vardate = Format ( ADate , "dd-mmm-yyyy hh:mm:ss" )

db.Execute("Insert into FZTempTbl(EntryDate) Values(" & _
"TO_DATE('" & vardate  & "')

any one help me??

Back to comp.lang.basic.visual.misc | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

Re: How To insert Date From VB6.0 to Oracle #2 tonisukmana <tonie_id@yahoo.com> - 2015-01-19 12:12 -0600
  Re: How To insert Date From VB6.0 to Oracle #2 GS <gs@somewhere.net> - 2015-01-19 16:31 -0500
  Re: How To insert Date From VB6.0 to Oracle #2 Deanna Earley <dee@earlsoft.co.uk> - 2015-01-20 09:22 +0000

csiph-web