Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
| Search | Today's Posts | Mark Forums Read
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 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 12th, 2006, 04:53 PM
Registered User
 
Join Date: Sep 2006
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default converting colum in datetime format...

Hi,

I have a text file that contains a date column. The text file will be
imported to database in SQL 2000 server. After to be importing, I want
to convert the date column to date type.

For ex. the text file look like

Name date
Smith 06092006 023718

It would be converted date column to ydm database in SQL 2000 server.
In the table it should look like this

Name Date
Smith 2006-09-06 hh:mm:ss.mmm

i used the query

select convert(varchar(15), getdate(), 25) from table name

which gives me the current date in the desired format...how can i replace the current date parameter to include the column 'Date'???


please assist...
thanks in advnce...





Similar Threads
Thread Thread Starter Forum Replies Last Post
Syntax error converting datetime from character st vinod_yadav1919 SQL Server 2000 2 September 10th, 2010 10:11 AM
converting char to datetime format santoshpayal SQL Language 0 September 11th, 2006 06:13 PM
Converting datetime to milliseconds since.. ravishakya SQL Server 2000 1 September 11th, 2006 07:47 AM
Syntax error converting datetime from character st kkrish SQL Server 2000 11 September 6th, 2006 06:46 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.