Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.basic.visual.misc > #2231
| From | GS <gs@somewhere.net> |
|---|---|
| Newsgroups | comp.lang.basic.visual.misc |
| Subject | Re: How To insert Date From VB6.0 to Oracle #2 |
| Date | 2015-01-19 16:31 -0500 |
| Organization | A noiseless patient Spider |
| Message-ID | <m9jt2t$s8m$1@dont-email.me> (permalink) |
| References | <1115223540.528401.47840@o13g2000cwo.googlegroups.com> <oPudnaIWF7aX1CDJnZ2dnUU7-VWdnZ2d@giganews.com> |
> 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??
Does your date include time? This does...
?format(now(), "dd-mmm-yyyy hh:mm:ss")
..and returns...
"19-Jan-2015 16:28:07"
..when typed in the Immediate Window!
--
Garry
Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
Back to comp.lang.basic.visual.misc | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll 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