Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi,
We have had a similar problem and have created a SQL Server User Written Function that we refer to as a sql FUNCTION whenever the date only is required:
CREATE FUNCTION dbo.xfn__DateOnly (@vcDateTime datetime)
RETURNS VarChar(10)
WITH SCHEMABINDING
AS
BEGIN
RETURN CONVERT(VarChar(12), @vcDateTime, 101)
END
-----------
The above code creates the function in the local Database User Defined Function area as XFN__DateOnly (with source code). We then move the compiled function into the Master UDF as fn__DateOnly (without sourcecode).
Then in a SQL Stored Procedure
SELECT vcTransNoIN, dtIssuedIN = FN__DATEONLY(dtIssuedIN), etc.....
I hope this helps?
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement