Member Avatar for jamesrobb

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.

  • 2 Contributors
  • 1 Reply
  • 99 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by Ramy Mahrous
Member Avatar for Ramy Mahrous

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.