Click here to Skip to main content
15,918,125 members
Home / Discussions / Database
   

Database

 
GeneralRe: How to Grouped Data weekly monthly and Quarterly Pin
Rameez Raja14-Jul-08 23:56
Rameez Raja14-Jul-08 23:56 
GeneralRe: How to Grouped Data weekly monthly and Quarterly Pin
Mycroft Holmes15-Jul-08 0:10
professionalMycroft Holmes15-Jul-08 0:10 
AnswerRe: How to Group Data weekly monthly and Quarterly Pin
leoinfo15-Jul-08 4:33
leoinfo15-Jul-08 4:33 
QuestionHow to set the timer for SSIS package Pin
nagveni14-Jul-08 12:39
nagveni14-Jul-08 12:39 
AnswerRe: How to set the timer for SSIS package Pin
Marek Grzenkowicz15-Jul-08 22:58
Marek Grzenkowicz15-Jul-08 22:58 
GeneralRe: How to set the timer for SSIS package Pin
nagveni16-Jul-08 10:05
nagveni16-Jul-08 10:05 
GeneralRe: How to set the timer for SSIS package Pin
Marek Grzenkowicz19-Jul-08 9:50
Marek Grzenkowicz19-Jul-08 9:50 
Questionconvert datetime format Pin
tai-fun14-Jul-08 11:01
tai-fun14-Jul-08 11:01 
(i can speak some engish so i hope you are understand o my writes)
using sql server 2005;

how to convertdatetime as yyyy/mm/dd hh:mm

i write a user defined function as below but that function result show as 2008-07-14 23:07:00.000.... i want result of function show as 2008-07-14 23:07 or 14-07-2008 23:07


CREATE FUNCTION [dbo].[TarihDuzenle] (@TARIH DATETIME)
RETURNS DATETIME
AS
BEGIN
SET @TARIH = CONVERT(
DATETIME, CONVERT(VARCHAR, DATEPART(YYYY,@TARIH)) +'/'+
CONVERT(VARCHAR, DATEPART(MM,@TARIH)) +'/'+
CONVERT(VARCHAR, DATEPART(DD,@TARIH)) + ' '+
CONVERT(VARCHAR, DATEPART(HH,@TARIH)) + ':'+
CONVERT(VARCHAR, DATEPART(MM,@TARIH)) + ':00'
)
RETURN @TARIH
END
AnswerRe: convert datetime format Pin
Arindam Tewary14-Jul-08 22:09
professionalArindam Tewary14-Jul-08 22:09 
GeneralRe: convert datetime format Pin
tai-fun15-Jul-08 1:15
tai-fun15-Jul-08 1:15 
AnswerRe: convert datetime format Pin
leoinfo15-Jul-08 5:35
leoinfo15-Jul-08 5:35 
QuestionBULK INSERT and collation problem Pin
msx2314-Jul-08 10:56
msx2314-Jul-08 10:56 
AnswerRe: BULK INSERT and collation problem Pin
Syed Mehroz Alam15-Jul-08 1:08
Syed Mehroz Alam15-Jul-08 1:08 
QuestionWhere To Buy SQL 2000 Reporting Service? [modified] Pin
thundernow14-Jul-08 4:21
thundernow14-Jul-08 4:21 
AnswerRe: Where To Buy SQL 2000 Reporting Service? Pin
DerekFL14-Jul-08 7:51
DerekFL14-Jul-08 7:51 
QuestionFind Last week dates? Pin
Member 387988114-Jul-08 3:04
Member 387988114-Jul-08 3:04 
AnswerRe: Find Last week dates? Pin
subai14-Jul-08 3:21
subai14-Jul-08 3:21 
AnswerRe: Find Last week dates? Pin
leoinfo14-Jul-08 3:35
leoinfo14-Jul-08 3:35 
AnswerRe: Find Last week dates? Pin
TheFM23414-Jul-08 6:26
TheFM23414-Jul-08 6:26 
JokeRe: Find Last week dates? Pin
leoinfo14-Jul-08 18:27
leoinfo14-Jul-08 18:27 
GeneralRe: Find Last week dates? Pin
TheFM23415-Jul-08 3:24
TheFM23415-Jul-08 3:24 
GeneralRe: Find Last week dates? [modified] Pin
Member 387988114-Jul-08 18:47
Member 387988114-Jul-08 18:47 
QuestionHow to write query Pin
BalasubramanianK14-Jul-08 0:23
BalasubramanianK14-Jul-08 0:23 
AnswerRe: How to write query Pin
TheFM23414-Jul-08 6:53
TheFM23414-Jul-08 6:53 
GeneralRe: How to write query Pin
BalasubramanianK14-Jul-08 18:17
BalasubramanianK14-Jul-08 18:17 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.