Click here to Skip to main content
15,920,111 members
Home / Discussions / Database
   

Database

 
AnswerRe: How to issue setup to the different users according to their membership with windows application? Pin
Mycroft Holmes16-Jul-13 20:20
professionalMycroft Holmes16-Jul-13 20:20 
QuestionSQL Server file locations. Pin
Septimus Hedgehog16-Jul-13 0:05
Septimus Hedgehog16-Jul-13 0:05 
AnswerRe: SQL Server file locations. Pin
Corporal Agarn16-Jul-13 1:49
professionalCorporal Agarn16-Jul-13 1:49 
GeneralRe: SQL Server file locations. Pin
Septimus Hedgehog16-Jul-13 3:18
Septimus Hedgehog16-Jul-13 3:18 
GeneralRe: SQL Server file locations. Pin
Corporal Agarn16-Jul-13 4:18
professionalCorporal Agarn16-Jul-13 4:18 
GeneralRe: SQL Server file locations. Pin
Septimus Hedgehog16-Jul-13 4:44
Septimus Hedgehog16-Jul-13 4:44 
QuestionHow to replace string with stuff ? Pin
caulsonchua15-Jul-13 23:03
caulsonchua15-Jul-13 23:03 
AnswerRe: How to replace string with stuff ? Pin
Richard Deeming16-Jul-13 1:37
mveRichard Deeming16-Jul-13 1:37 
Don't store dates as strings, and don't use string methods to manipulate dates. If you have any control over this database, you should change the EP_SCAN_DATE column to be a datetime.

You haven't specified which DBMS you're using. Assuming MS SQL, you can use something like this:
SQL
SELECT DateAdd(hour, 9, DateDiff(dd, 0, YourDateTimeColumn))

The DateDiff(dd, 0, X) will return just the date part of X, with the time set to midnight. You then use DateAdd to add as many hours, minutes and seconds as you require.



"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer


GeneralRe: How to replace string with stuff ? Pin
caulsonchua16-Jul-13 1:39
caulsonchua16-Jul-13 1:39 
GeneralRe: How to replace string with stuff ? Pin
Richard Deeming16-Jul-13 1:50
mveRichard Deeming16-Jul-13 1:50 
AnswerRe: How to replace string with stuff ? Pin
Mycroft Holmes16-Jul-13 12:44
professionalMycroft Holmes16-Jul-13 12:44 
QuestionMounting .DBF files (Oracle Database 11g) Pin
prathameshpitale15-Jul-13 5:33
prathameshpitale15-Jul-13 5:33 
AnswerRe: Mounting .DBF files (Oracle Database 11g) Pin
Maciej Los29-Jul-13 23:46
mveMaciej Los29-Jul-13 23:46 
GeneralRe: Mounting .DBF files (Oracle Database 11g) Pin
prathameshpitale30-Jul-13 5:40
prathameshpitale30-Jul-13 5:40 
QuestionORA-12560 TNS : protocol adapter error; ORA-1033 Oracle initialization or shutdown in progress Pin
prathameshpitale15-Jul-13 5:33
prathameshpitale15-Jul-13 5:33 
QuestionHow to find ladder in sql query Pin
Member 356741115-Jul-13 2:02
Member 356741115-Jul-13 2:02 
AnswerRe: How to find ladder in sql query Pin
Niral Soni15-Jul-13 5:00
Niral Soni15-Jul-13 5:00 
AnswerRe: How to find ladder in sql query Pin
karna from Hyderabad22-Jul-13 21:01
karna from Hyderabad22-Jul-13 21:01 
Questiondatabase course Pin
V.14-Jul-13 22:32
professionalV.14-Jul-13 22:32 
AnswerRe: database course Pin
Eddy Vluggen15-Jul-13 0:30
professionalEddy Vluggen15-Jul-13 0:30 
GeneralRe: database course Pin
V.15-Jul-13 1:30
professionalV.15-Jul-13 1:30 
QuestionFIlestream of varbinary ? ( To Store files) Pin
Amol_B14-Jul-13 21:22
professionalAmol_B14-Jul-13 21:22 
AnswerRe: FIlestream of varbinary ? ( To Store files) Pin
Richard MacCutchan14-Jul-13 22:29
mveRichard MacCutchan14-Jul-13 22:29 
AnswerRe: FIlestream of varbinary ? ( To Store files) Pin
Mycroft Holmes14-Jul-13 22:42
professionalMycroft Holmes14-Jul-13 22:42 
GeneralRe: FIlestream of varbinary ? ( To Store files) Pin
Amol_B14-Jul-13 22:58
professionalAmol_B14-Jul-13 22:58 

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.