Click here to Skip to main content
15,923,083 members
Home / Discussions / Database
   

Database

 
GeneralRe: Create an sql script that compares two dbase and updates dbase and insert date of update in a column in oracle 11g Pin
Eddy Vluggen20-May-13 9:51
professionalEddy Vluggen20-May-13 9:51 
GeneralRe: Create an sql script that compares two dbase and updates dbase and insert date of update in a column in oracle 11g Pin
Miguel Quintanilla20-May-13 16:23
Miguel Quintanilla20-May-13 16:23 
GeneralRe: Create an sql script that compares two dbase and updates dbase and insert date of update in a column in oracle 11g Pin
Eddy Vluggen20-May-13 19:45
professionalEddy Vluggen20-May-13 19:45 
AnswerRe: Create an sql script that compares two dbase and updates dbase and insert date of update in a column in oracle 11g Pin
Mycroft Holmes16-May-13 21:24
professionalMycroft Holmes16-May-13 21:24 
GeneralRe: Create an sql script that compares two dbase and updates dbase and insert date of update in a column in oracle 11g Pin
Miguel Quintanilla20-May-13 7:09
Miguel Quintanilla20-May-13 7:09 
GeneralRe: Create an sql script that compares two dbase and updates dbase and insert date of update in a column in oracle 11g Pin
Mycroft Holmes20-May-13 12:25
professionalMycroft Holmes20-May-13 12:25 
GeneralRe: Create an sql script that compares two dbase and updates dbase and insert date of update in a column in oracle 11g Pin
Miguel Quintanilla20-May-13 16:11
Miguel Quintanilla20-May-13 16:11 
QuestionCreate a procedure to change date value of a column in a table ? (SQL) Pin
taibc15-May-13 21:09
taibc15-May-13 21:09 
Hi everyone,

I have a table with the name is: Detail, that includes 'DateOfBirth' column (datetime type). For example: 1986-06-16 00:00:00.000

Now I want to create a store procedure to swap "day" value and "month" value for date values that have "day" and "month" value smaller 13, such as :

Origin value: 1984-05-10 (10th May)
Expected value: 1984-10-05 (5th Oct)

Do you know how can do that ?

Thanks and regards,

Tai
AnswerRe: Create a procedure to change date value of a column in a table ? (SQL) Pin
Corporal Agarn16-May-13 1:18
professionalCorporal Agarn16-May-13 1:18 
GeneralRe: Create a procedure to change date value of a column in a table ? (SQL) Pin
taibc16-May-13 3:41
taibc16-May-13 3:41 
GeneralRe: Create a procedure to change date value of a column in a table ? (SQL) Pin
Corporal Agarn16-May-13 3:49
professionalCorporal Agarn16-May-13 3:49 
AnswerRe: Create a procedure to change date value of a column in a table ? (SQL) Pin
Eddy Vluggen16-May-13 3:16
professionalEddy Vluggen16-May-13 3:16 
GeneralRe: Create a procedure to change date value of a column in a table ? (SQL) Pin
taibc16-May-13 3:34
taibc16-May-13 3:34 
GeneralRe: Create a procedure to change date value of a column in a table ? (SQL) Pin
Eddy Vluggen16-May-13 3:48
professionalEddy Vluggen16-May-13 3:48 
GeneralLooking for the best solution Pin
MacAriel15-May-13 8:40
MacAriel15-May-13 8:40 
QuestionDeploying SSIS Package and calling it from Console application Pin
indian14315-May-13 7:28
indian14315-May-13 7:28 
AnswerRe: Deploying SSIS Package and calling it from Console application Pin
unclepaul15-May-13 8:47
unclepaul15-May-13 8:47 
AnswerRe: Deploying SSIS Package and calling it from Console application Pin
Mycroft Holmes15-May-13 18:00
professionalMycroft Holmes15-May-13 18:00 
QuestionCreate trigger that executes on date Pin
damokk15-May-13 3:54
damokk15-May-13 3:54 
AnswerRe: Create trigger that executes on date Pin
Corporal Agarn15-May-13 6:31
professionalCorporal Agarn15-May-13 6:31 
AnswerRe: Create trigger that executes on date Pin
Mycroft Holmes15-May-13 17:55
professionalMycroft Holmes15-May-13 17:55 
GeneralRe: Create trigger that executes on date Pin
damokk15-May-13 23:06
damokk15-May-13 23:06 
GeneralRe: Create trigger that executes on date Pin
damokk15-May-13 23:08
damokk15-May-13 23:08 
GeneralRe: Create trigger that executes on date Pin
Mycroft Holmes15-May-13 23:33
professionalMycroft Holmes15-May-13 23:33 
GeneralRe: Create trigger that executes on date Pin
damokk15-May-13 23:47
damokk15-May-13 23:47 

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.