Click here to Skip to main content
15,907,000 members
Home / Discussions / Database
   

Database

 
AnswerRe: Reading/Writing text files in Oracle Pin
andyharman2-Jul-07 0:30
professionalandyharman2-Jul-07 0:30 
GeneralRe: Reading/Writing text files in Oracle Pin
Mangilipelli2-Jul-07 4:33
Mangilipelli2-Jul-07 4:33 
Questionsql server2000 Pin
ahmedalisha1-Jul-07 21:15
ahmedalisha1-Jul-07 21:15 
AnswerRe: sql server2000 Pin
andyharman1-Jul-07 22:37
professionalandyharman1-Jul-07 22:37 
AnswerRe: sql server2000 Pin
N a v a n e e t h1-Jul-07 22:42
N a v a n e e t h1-Jul-07 22:42 
AnswerRe: sql server2000 Pin
Sgg2451-Jul-07 23:16
Sgg2451-Jul-07 23:16 
GeneralRe: sql server2000 Pin
ahmedalisha1-Jul-07 23:25
ahmedalisha1-Jul-07 23:25 
GeneralRe: sql server2000 Pin
Sgg2452-Jul-07 0:06
Sgg2452-Jul-07 0:06 
The datatype of the column should be DATETIME...

Use the following type query::
select convert(varchar(10), c6, 108) from t1

In this query, Column 'c6' is of DATETIME type and this query will give you only time part of the column and over this you can use DATEDIFF() function...


Regards
SG (sgg245@yahoo.co.in)

Questionchange case of a text field Pin
rkherath1-Jul-07 20:40
rkherath1-Jul-07 20:40 
AnswerRe: change case of a text field Pin
Sgg2451-Jul-07 21:11
Sgg2451-Jul-07 21:11 
QuestionPlz Help Me!! Urgently... Anybody for Merge Replication... Pin
Sgg2451-Jul-07 18:38
Sgg2451-Jul-07 18:38 
AnswerRe: Plz Help Me!! Urgently... Anybody for Merge Replication... Pin
Paul Conrad13-Jul-07 11:56
professionalPaul Conrad13-Jul-07 11:56 
QuestionHow to get list of tables in SQL Server Pin
Prashant C1-Jul-07 17:52
Prashant C1-Jul-07 17:52 
AnswerRe: How to get list of tables in SQL Server Pin
PrakashBhaskar1-Jul-07 18:21
PrakashBhaskar1-Jul-07 18:21 
AnswerRe: How to get list of tables in SQL Server Pin
Krish - KP1-Jul-07 18:27
Krish - KP1-Jul-07 18:27 
GeneralRe: How to get list of tables in SQL Server Pin
sajjadtx1-Jul-07 18:33
sajjadtx1-Jul-07 18:33 
GeneralRe: How to get list of tables in SQL Server Pin
Krish - KP1-Jul-07 23:26
Krish - KP1-Jul-07 23:26 
AnswerRe: How to get list of tables in SQL Server Pin
Aaron VanWieren2-Jul-07 3:32
Aaron VanWieren2-Jul-07 3:32 
QuestionHow to schedule the job using stored procedure Pin
madhu071-Jul-07 7:15
madhu071-Jul-07 7:15 
QuestionHow to schedule the job using stored procedure Pin
madhu071-Jul-07 7:13
madhu071-Jul-07 7:13 
Questionschedual Jobs Pin
merwa1-Jul-07 3:42
merwa1-Jul-07 3:42 
Questioncheck constrain on colum Pin
merwa30-Jun-07 22:52
merwa30-Jun-07 22:52 
AnswerRe: check constrain on colum Pin
Gamzun30-Jun-07 23:17
Gamzun30-Jun-07 23:17 
GeneralRe: check constrain on colum Pin
merwa1-Jul-07 3:39
merwa1-Jul-07 3:39 
GeneralRe: check constrain on colum Pin
Gamzun1-Jul-07 3:44
Gamzun1-Jul-07 3:44 

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.