Concatenating Date and Time from two differnt fields

's Computer Specifications

Hi,
I have two different text boxes. One is for reading user input date and the
other is for reading user input time.
How can concatenate both of the two fields and save them as one data value
to a datetime field in the database? I'm using SQL 2005.

's Computer Specifications

eg.
Dim x As DateTime = Convert.ToDateTime("19-Feb-2008 " + "3:45pm")

Regards
JIGNESH

"Tamer Ibrahim" wrote:

> Hi,
> I have two different text boxes. One is for reading user input date and the
> other is for reading user input time.
> How can concatenate both of the two fields and save them as one data value
> to a datetime field in the database? I'm using SQL 2005.
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
concatenating two fields in one cell, of which one is a date.	Manuel Murieta	Microsoft Excel Discussion	3	8th Feb 2007 10:15 PM
RE: CONCATENATING DATE AND TIME	=?Utf-8?B?R2FyeScncyBTdHVkZW50?=	Microsoft Excel Worksheet Functions	0	10th Nov 2005 12:34 AM
Concatenating Date and Time	=?Utf-8?B?U2hlcndvb2Q=?=	Microsoft Outlook VBA Programming	1	7th Sep 2005 10:02 AM
Concatenating Date and Time Fields for Lag Time Analyses	=?Utf-8?B?UmljaFQ=?=	Microsoft Access Queries	2	3rd Aug 2004 07:05 PM
Re: Concatenating date fields into text	David Morrison	Microsoft Excel Worksheet Functions	0	25th Jun 2003 05:05 PM