Technical Article

Adds TIME portion of a DT to the DATE of another

UDF that returns a DATETIME which is the concatination of the TIME portion of one DATETIME and the DATE portion of another.EXAMPLES:DECLARE @Date DATETIME, @Time DATETIMESET @Date = '7/1/03 16:00'SET @Time = '5/16/1999 9:30 AM'PRINT dbo.FN_AddDateTime(@Date,@Time )RETURNS: Jul  1 2003  9:30AMPRINT dbo.FN_AddDateTime(@Date,0)RETURNS: Jul  1 2003 12:00AM

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-07-01

115 reads

Blogs

DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods

By

Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...

T-SQL Tuesday #203: Risk and Reward

By

This is timely, as I’m currently on a boat in the Adriatic taking a...

dataMinds Connect 2026 – Slides & Scripts

By

You can find the slides and SQL scripts for my session “Spice up your...

Read the latest Blogs

Forums

Alamat BCA KCP Pondok Ungu Bekasi Telp:0821°8200°233

By layanan_Bca88

Telp/Wa 628218200233 Jl. Sultan Agung No.19-20 Kavling Blok A, RT.007/RW.007, Medan Satria, Kecamatan Medan...

Alamat BCA KCP Central Park Telp:0821°8200°203

By R4nt4u

Telp/Wa 628218200203 Ruko GSA Blok Beufort 08 CB CC CD, RT.9/RW.5, South Tanjung Duren,...

Alamat BCA KCP Ruko Swadaya Telp:0821°7555°651

By m4rt1n4

Telp/Wa 628217555651 Jl. Swadaya Raya No. 39 Ruko Swadaya City Square Blok 1. 11-23,...

Visit the forum

Question of the Day

PostgreSQL psql Meta Commands: Tables

Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?

See possible answers