Click here to Skip to main content
15,887,846 members
Home / Discussions / Database
   

Database

 
QuestionHow to get exactly date from Oracle Link DB in SQL server. Pin
hmanhha3-Mar-16 16:07
hmanhha3-Mar-16 16:07 
AnswerRe: How to get exactly date from Oracle Link DB in SQL server. Pin
Mycroft Holmes3-Mar-16 19:18
professionalMycroft Holmes3-Mar-16 19:18 
GeneralRe: How to get exactly date from Oracle Link DB in SQL server. Pin
hmanhha3-Mar-16 22:53
hmanhha3-Mar-16 22:53 
GeneralRe: How to get exactly date from Oracle Link DB in SQL server. Pin
Richard MacCutchan3-Mar-16 23:22
mveRichard MacCutchan3-Mar-16 23:22 
GeneralRe: How to get exactly date from Oracle Link DB in SQL server. Pin
Mycroft Holmes4-Mar-16 12:52
professionalMycroft Holmes4-Mar-16 12:52 
GeneralRe: How to get exactly date from Oracle Link DB in SQL server. Pin
hmanhha6-Mar-16 16:52
hmanhha6-Mar-16 16:52 
GeneralRe: How to get exactly date from Oracle Link DB in SQL server. Pin
Mycroft Holmes6-Mar-16 19:56
professionalMycroft Holmes6-Mar-16 19:56 
GeneralRe: How to get exactly date from Oracle Link DB in SQL server. Pin
hmanhha6-Mar-16 22:09
hmanhha6-Mar-16 22:09 
Now I Use T-SQL

select
Moto.ne_code,

Moto.sta_datetime,

convert(varchar(10),sta_datetime,111) as Sdate,
convert(time,sta_datetime) as S_Time,
Moto.province_id,
Moto.ne_id,
bss_cssr cssrv1,
tchtc traffic,
cssr cssrv2,
hosr_v2 hosrv2,
dropc dcr,
dcr_v2 dcrv2,
cavl calvol,
hansr hosr,
tchblor tchblr,
sdcchbr sdcchblkr


from OracleDBLink
where

convert(varchar(10),sta_datetime,111) = CONVERT(varchar(10), getdate()-1,111)
and ((bss_cssr <=95) or (dropc>=3) or (hansr<=95)) and cavl>=50

it seem to be OK get the result as I Want.

But I can Put it in the View.
I Want to creat a job to do it everytime
GeneralRe: How to get exactly date from Oracle Link DB in SQL server. Pin
Jörgen Andersson7-Mar-16 6:35
professionalJörgen Andersson7-Mar-16 6:35 
QuestionConvert Text to datetime Pin
Jassim Rahma2-Mar-16 10:29
Jassim Rahma2-Mar-16 10:29 
AnswerRe: Convert Text to datetime Pin
NickPace2-Mar-16 12:28
NickPace2-Mar-16 12:28 
GeneralRe: Convert Text to datetime Pin
Mycroft Holmes2-Mar-16 19:07
professionalMycroft Holmes2-Mar-16 19:07 
GeneralRe: Convert Text to datetime Pin
NickPace3-Mar-16 4:59
NickPace3-Mar-16 4:59 
Questionbest local database for large tables? (C#, .net) Pin
Frank R. Haugen29-Feb-16 11:00
professionalFrank R. Haugen29-Feb-16 11:00 
QuestionRe: best local database for large tables? (C#, .net) Pin
Jörgen Andersson29-Feb-16 11:46
professionalJörgen Andersson29-Feb-16 11:46 
AnswerRe: best local database for large tables? (C#, .net) Pin
Frank R. Haugen29-Feb-16 12:11
professionalFrank R. Haugen29-Feb-16 12:11 
SuggestionRe: best local database for large tables? (C#, .net) Pin
Richard MacCutchan29-Feb-16 22:07
mveRichard MacCutchan29-Feb-16 22:07 
GeneralRe: best local database for large tables? (C#, .net) Pin
Sascha Lefèvre1-Mar-16 1:34
professionalSascha Lefèvre1-Mar-16 1:34 
GeneralRe: best local database for large tables? (C#, .net) Pin
Richard MacCutchan1-Mar-16 1:43
mveRichard MacCutchan1-Mar-16 1:43 
GeneralRe: best local database for large tables? (C#, .net) Pin
Jörgen Andersson29-Feb-16 23:24
professionalJörgen Andersson29-Feb-16 23:24 
AnswerRe: best local database for large tables? (C#, .net) Pin
GuyThiebaut1-Mar-16 0:16
professionalGuyThiebaut1-Mar-16 0:16 
GeneralRe: best local database for large tables? (C#, .net) Pin
Frank R. Haugen2-Mar-16 22:14
professionalFrank R. Haugen2-Mar-16 22:14 
GeneralRe: best local database for large tables? (C#, .net) Pin
GuyThiebaut2-Mar-16 22:33
professionalGuyThiebaut2-Mar-16 22:33 
AnswerRe: best local database for large tables? (C#, .net) Pin
peterkmx2-Mar-16 5:46
professionalpeterkmx2-Mar-16 5:46 
AnswerRe: best local database for large tables? (C#, .net) Pin
Brisingr Aerowing2-Mar-16 16:24
professionalBrisingr Aerowing2-Mar-16 16:24 

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.