Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > ADO.NET
ADO.NET For discussion about ADO.NET.  Topics such as question regarding the System.Data namespace are appropriate.  Questions specific to a particular application should be posted in a forum specific to the application .
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ADO.NET section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old July 10th, 2003, 07:48 PM
Registered User
Join Date: Jun 2003
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to samlow82 Send a message via Yahoo to samlow82
Default How to query Date format in Oracle

I'm using Oracle and have some problem about date format.
Dim command As New OleDb.OleDbCommand()
command.Connection = connection
command.CommandText = "SELECT COUNT(*) AS COUNT FROM CAR WHERE DATE_KEYIN = '07/07/2003'"
Dim datRead = command.ExecuteReader()
Do Until datRead.Read = False
  tb1.Text = datRead(0)

I saw the date that was already insert into table is in format 'M/D/YYYY', without hh:mm:ss .
But i search high and low this format is supported in Oracle.
However, it will prompt me ERROR "ORA-01843 Not a valid month"
It's urgent, can somebody help me?
Old July 18th, 2003, 04:34 AM
Registered User
Join Date: Jul 2003
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem in Date Format in query imagetvr Pro VB 6 1 February 4th, 2008 06:03 PM
Convert British format date to American format? fyr PHP How-To 0 December 19th, 2007 03:17 PM
date format differs, need to force format somehow patricolsson HTML Code Clinic 2 January 12th, 2006 05:55 AM
Oracle Sequence No , Date format ssertial BOOK: Beginning VB.NET 2nd Edition/Beginning VB.NET 2003 2 January 23rd, 2005 06:01 AM
Date Format problem in Oracle ppenn Oracle ASP 1 May 10th, 2004 06:00 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.