User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the VB.NET section within the Software Development category of DaniWeb, a massive community of 456,565 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,583 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our VB.NET advertiser: Programming Forums
Views: 7518 | Replies: 1
Reply
Join Date: Oct 2007
Posts: 1
Reputation: jamesrobb is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
jamesrobb jamesrobb is offline Offline
Newbie Poster

Convert date to timestamp format

  #1  
Oct 23rd, 2007
Hi,
I've got a date field such as:
Dim Ndate As System.DateTime = System.DateTime.Today.AddDays(-14).
I need to be able to use Ndate to access a date field in an Oracle table that is in a timestamp format. Can anyone help?
Thanks.
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Aug 2006
Location: Egypt
Posts: 763
Reputation: RamyMahrous is on a distinguished road 
Rep Power: 4
Solved Threads: 59
Featured Poster
RamyMahrous's Avatar
RamyMahrous RamyMahrous is offline Offline
Master Poster

Re: Convert date to timestamp format

  #2  
Oct 23rd, 2007
let's use datatypes well, we just need timestamp: data type that exposes automatically generated binary numbers, which are guaranteed to be unique within a database. timestamp is used typically as a mechanism for version-stamping table rows.

So, you don't need to modify it, it's modified by SQL or Oracle engine

Differentiate between DateTime and TimeStamp datatypes
B.Sc Computer Science, Helwan University
Microsoft Student Partner
Personal blog http://ramymahrous.blogspot.com/
Arabic technical blog http://fci-h-ar.blogspot.com/
English technical blog http://fci-h.blogspot.com/
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

DaniWeb VB.NET Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Similar Threads
Other Threads in the VB.NET Forum

All times are GMT -4. The time now is 5:51 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC