DECLARE @a CHAR(12); DECLARE @b DATETIME; DECLARE @c INT;...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

DECLARE @a CHAR(12);
DECLARE @b DATETIME;
DECLARE @c INT;
SET @b='3.04.04';
SET @c=6;
SET @a=CAST(@b-CAST(@c AS DATETIME) AS CHAR(12))
SELECT @a;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results