Click here to Skip to main content
15,885,278 members
Home / Discussions / Database
   

Database

 
AnswerRe: datetime code Pin
Sathesh Sakthivel28-Jun-07 2:22
Sathesh Sakthivel28-Jun-07 2:22 
Questiondatetime problem Pin
niki_nilu28-Jun-07 0:54
niki_nilu28-Jun-07 0:54 
AnswerRe: datetime problem Pin
Krish - KP28-Jun-07 1:30
Krish - KP28-Jun-07 1:30 
GeneralRe: datetime problem Pin
FishiFishi28-Jun-07 3:16
FishiFishi28-Jun-07 3:16 
AnswerRe: datetime problem Pin
Pratik Vasant Shah28-Jun-07 20:19
Pratik Vasant Shah28-Jun-07 20:19 
Questionhow to pass null values to a query in the design time Pin
pashitech28-Jun-07 0:12
pashitech28-Jun-07 0:12 
AnswerRe: how to pass null values to a query in the design time Pin
Xandip28-Jun-07 20:13
Xandip28-Jun-07 20:13 
QuestionDate Time String Transformation sample mssql Pin
cutequencher27-Jun-07 23:18
cutequencher27-Jun-07 23:18 
here's my query

select t.date_value, start_time,end_time,upper(r.last_name)+', '+r.first_name teacher_name,
datediff(hh,t.start_time,t.end_time)*t.rate total_rate,t.remarks
FROM dbo.ttcpCustomizedSchedule t left outer join dbo.ResourcePersons r
on r.teacher_id=t.teacher_id where t.tload_id = 5724 order by date_value

i want to make the start_time and endtime using a string format of:
"hh:mm tt"

please help me...

i am using mssql server 2000
AnswerRe: Date Time String Transformation sample mssql Pin
andyharman28-Jun-07 0:18
professionalandyharman28-Jun-07 0:18 
GeneralRe: Date Time String Transformation sample mssql Pin
cutequencher28-Jun-07 0:39
cutequencher28-Jun-07 0:39 
Questionsql data adapter.update Pin
Sebastian T Xavier27-Jun-07 22:42
Sebastian T Xavier27-Jun-07 22:42 
AnswerRe: sql data adapter.update Pin
Vimalsoft(Pty) Ltd28-Jun-07 22:35
professionalVimalsoft(Pty) Ltd28-Jun-07 22:35 
QuestionMySQL - C# - problem with charset encoding Pin
yarns27-Jun-07 22:26
yarns27-Jun-07 22:26 
AnswerRe: MySQL - C# - problem with charset encoding Pin
Giorgi Dalakishvili27-Jun-07 22:45
mentorGiorgi Dalakishvili27-Jun-07 22:45 
GeneralRe: MySQL - C# - problem with charset encoding Pin
yarns27-Jun-07 22:51
yarns27-Jun-07 22:51 
GeneralRe: MySQL - C# - problem with charset encoding Pin
Giorgi Dalakishvili27-Jun-07 22:53
mentorGiorgi Dalakishvili27-Jun-07 22:53 
GeneralRe: MySQL - C# - problem with charset encoding Pin
yarns27-Jun-07 23:19
yarns27-Jun-07 23:19 
GeneralRe: MySQL - C# - problem with charset encoding Pin
Giorgi Dalakishvili27-Jun-07 23:24
mentorGiorgi Dalakishvili27-Jun-07 23:24 
QuestionSaving Sybase Data to Excel Pin
meeram39527-Jun-07 20:26
meeram39527-Jun-07 20:26 
QuestionSQL Server 2005 Reporting Services Pin
Pratik Vasant Shah27-Jun-07 19:38
Pratik Vasant Shah27-Jun-07 19:38 
AnswerRe: SQL Server 2005 Reporting Services Pin
martin_hughes28-Jun-07 8:20
martin_hughes28-Jun-07 8:20 
QuestionRe: SQL Server 2005 Reporting Services Pin
Pratik Vasant Shah28-Jun-07 20:21
Pratik Vasant Shah28-Jun-07 20:21 
AnswerRe: SQL Server 2005 Reporting Services Pin
martin_hughes29-Jun-07 1:35
martin_hughes29-Jun-07 1:35 
QuestionSQL Inner Join? Pin
Expert Coming27-Jun-07 14:56
Expert Coming27-Jun-07 14:56 
AnswerRe: SQL Inner Join? Pin
Chinnakasu27-Jun-07 16:31
Chinnakasu27-Jun-07 16:31 

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.