Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > SQL Language
|
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
 
Old September 11th, 2006, 06:13 PM
Registered User
 
Join Date: Sep 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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





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