![]() |
datetime tarih formatı date çevirme |
Post Reply ![]() |
|
Author | |
mcitp ![]() Newbie ![]() Joined: 16 Ağustos 2018 Location: ankara Status: Offline Points: 18 |
![]() ![]() ![]() ![]() ![]() Posted: 06 Kasım 2020 at 18:21 |
merhaba aşağıdaki kodlarda tarih Örn: 2011-03-14 00:00:00 bu şekilde geliyor bunu nasıl 14.03.2011 şekline çevirebiliriz teşekkür ederim iyi çalışmalar GO /****** Object: UserDefinedFunction [dbo].[fn_DateTimeKontrol] Script Date: 11/06/2020 17:48:46 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER FUNCTION [dbo].[fn_DateTimeKontrol](@dt as datetime) RETURNS Datetime AS BEGIN RETURN ( CASE WHEN @dt<'1900-1-1' THEN NULL ELSE @dt END ) END Edited by mcitp - 06 Kasım 2020 at 18:22 |
|
![]() |
|
mcitp ![]() Newbie ![]() Joined: 16 Ağustos 2018 Location: ankara Status: Offline Points: 18 |
![]() ![]() ![]() ![]() ![]() |
yok mu cevap yazabilecek kimse
|
|
![]() |
Post Reply ![]() |
|
Tweet
|
|
Forum Jump | Forum Permissions ![]() You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |