RE: Pulling data from 2 columns

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Brandon Lilly (avarice_at_nospam_swbell.net)
Date: 12/28/04 

Date: Tue, 28 Dec 2004 12:41:02 -0800

If you are just wanting to grab the date from one column and the time from
another, you can do something like this:

DECLARE @DateAndTime datetime
DECLARE @TimeOnly datetime

SET @DateAndTime = 'DEC 10, 2004 10:01AM'
SET @TimeOnly = '10:04AM'

SELECT CAST(CONVERT(char(8), @DateAndTime, 112) + ' ' + CONVERT(char(5),
@TimeOnly, 114) AS datetime) AS TransmissionTime

Just replace the variables in the query with your columns.

Brandon

Relevant Pages

  • Re: Spalten alternativ ansprechen
    ... DECLARE @Monat INT ... '01' AS DATETIME) ... case when DATUM between '...' ... then UMSATZ as ...
    (microsoft.public.de.access.clientserver)
  • Re: a view based on stored procedure
    ... DECLARE @Week_1 DATETIME ... DECLARE @CubeTime DATETIME ... INSERT INTO WrkAvailPlanHours ...
    (microsoft.public.sqlserver.programming)
  • Re: Language problem
    ... @datum datetime ... > Then in application I have settings of my connection: ... > everything else doesn't because all other functions are set to slovenian. ... > DECLARE @dt DATETIME,@datumMesec dateTime,@datumTedenZ datetime,@datumTedenK ...
    (microsoft.public.sqlserver.programming)
  • RE: User Defined Function Help
    ... @startDateTime datetime = null, ... DECLARE @selectFromList varchar ... SET @subservice = RTRIM ... EXEC ...
    (microsoft.public.sqlserver.programming)
  • Re: get time in SQL server
    ... >conversion to datetime data type but could not do it. ... >declare @date2 as datetime ... declare @date1 varchar ...
    (microsoft.public.sqlserver.server)