Date

Wrox Programmer Forums

		Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > VB Databases Basics
Date

VB Databases Basics Beginning-level VB coding questions specific to using VB with databases. Issues not specific to database use will be redirected to other forums.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB Databases Basics 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

May 23rd, 2007, 02:07 AM

MathLearner MathLearner is offline

MathLearner is offline

Authorized User

Join Date: May 2007

Posts: 26

Thanks: 0

Thanked 0 Times in 0 Posts

Send a message via AIM to MathLearner

Default

Date

hi :(
how to insert date in sql using vb.
help us..

Old

May 31st, 2007, 10:55 AM

BrianWren

BrianWren is offline

Friend of Wrox

Join Date: Nov 2004

Posts: 1,621

Thanks: 1

Thanked 3 Times in 3 Posts

Default

Open a connection to your database.
Using that connection, run SQL against the database:

Code:

UPDATE MyTable
SET    DateField = TODATE( . . . )
WHERE  A_Field = 'TheRightCondition'

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Show Images from Start Date thru Date	istcomnet	Classic ASP Basics	2	May 23rd, 2008 07:12 AM
How to find a date range between another date rang	tayvonne	Access	2	August 3rd, 2006 09:50 AM
copy date values between date controls	Alcapone	Javascript How-To	1	April 13th, 2006 03:13 AM
DTS Import ( Date string to Date field)	gfowajuh	SQL Server 2000	1	September 30th, 2003 06:28 AM
Convert String Date to Date for a SQL Query	tdaustin	Classic ASP Basics	4	July 7th, 2003 06:01 PM