converting char to datetime format

		Wrox Programmer Forums > Database > SQL Language
converting char to datetime format

SQL Language SQL Language discussions not specific to a particular RDBMS program or vendor.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Language 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

September 11th, 2006, 06:13 PM

santoshpayal santoshpayal is offline

Registered User

Join Date: Sep 2006

Posts: 2

Thanks: 0

Thanked 0 Times in 0 Posts

converting char to datetime format

Hi All

i have a date time field which needs to be converted into datatime format to insert into sql db...

the format is
date
---------
06092006 023718

how do i useconvert function to convert into say...06/09/2006...

much thanks in advance...

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
converting colum in datetime format...	santoshpayal	SQL Server 2000	0	September 12th, 2006 04:53 PM
Converting datetime to milliseconds since..	ravishakya	SQL Server 2000	1	September 11th, 2006 07:47 AM
Converting BSTR to const char*	wambozi	C++ Programming	5	September 8th, 2006 05:08 AM
Converting BSTR to const char*	wambozi	C#	1	September 6th, 2006 05:37 AM
Error converting data type nvarchar to datetime.	Andreas	ADO.NET	2	August 18th, 2004 03:03 AM