Click here to Skip to main content
15,883,535 members
Home / Discussions / Database
   

Database

 
GeneralDublication of rows Pin
Vaibhav Sanghavi30-Oct-03 22:15
Vaibhav Sanghavi30-Oct-03 22:15 
GeneralRe: Dublication of rows Pin
Rahul Walavalkar3-Nov-03 2:54
Rahul Walavalkar3-Nov-03 2:54 
GeneralRe: Dublication of rows Pin
Vaibhav Sanghavi3-Nov-03 3:10
Vaibhav Sanghavi3-Nov-03 3:10 
GeneralSystem.Data.Sqlclient.TdsParser Pin
yyf30-Oct-03 9:27
yyf30-Oct-03 9:27 
GeneralConnectionString.Timeout Pin
yyf30-Oct-03 8:06
yyf30-Oct-03 8:06 
Generalsimple sample of ADO + Access + VC++ Pin
slomoman30-Oct-03 7:12
slomoman30-Oct-03 7:12 
Generaldate Pin
Anonymous30-Oct-03 6:30
Anonymous30-Oct-03 6:30 
GeneralRe: date Pin
andyharman3-Nov-03 11:26
professionalandyharman3-Nov-03 11:26 
Assuming that you are using SQL-Server:

The following will turn your fields into a datetime value:
convert(datetime, day1 + (100 * month1) + (10000 * year1) + (1000000 * century1))

The dateadd functiion will allow you to add one day.

Use convert(char(8), mydate, 112) to convert the date to a character field with the format "YYYYMMDD" (I think 112 is correct - i don't have SQL-server on this machine!).

Use substring to extract each element of the date into string values.

You should be able to stick it all together to solve your problem.
Andy
GeneralIDbCommand.CommandTimeOut Pin
yyf30-Oct-03 4:21
yyf30-Oct-03 4:21 
GeneralRe: IDbCommand.CommandTimeOut Pin
Mike Dimmick30-Oct-03 4:59
Mike Dimmick30-Oct-03 4:59 
GeneralRe: IDbCommand.CommandTimeOut Pin
yyf30-Oct-03 8:07
yyf30-Oct-03 8:07 
QuestionProblem in connection string??? Pin
d meenakshi29-Oct-03 18:53
d meenakshi29-Oct-03 18:53 
GeneralRows Pin
Anonymous29-Oct-03 9:17
Anonymous29-Oct-03 9:17 
GeneralUpdate and select in same procedure with a dataadapter Pin
MrDanJordan29-Oct-03 5:49
MrDanJordan29-Oct-03 5:49 
GeneralHelp, why sql server is pending..... Pin
yyf29-Oct-03 4:09
yyf29-Oct-03 4:09 
GeneralRe: Help, why sql server is pending..... Pin
Jeff Varszegi3-Nov-03 15:07
professionalJeff Varszegi3-Nov-03 15:07 
Generalabout connection pooling Pin
yyf28-Oct-03 10:12
yyf28-Oct-03 10:12 
QuestionThe functions in ADO.NET are asynchronism or synchronism? Pin
yyf28-Oct-03 9:14
yyf28-Oct-03 9:14 
GeneralDebugging a Stored Proc Pin
Dave S28-Oct-03 3:10
Dave S28-Oct-03 3:10 
GeneralRe: Debugging a Stored Proc Pin
Mike Dimmick28-Oct-03 3:15
Mike Dimmick28-Oct-03 3:15 
GeneralRe: Debugging a Stored Proc Pin
Jörgen Sigvardsson30-Oct-03 9:33
Jörgen Sigvardsson30-Oct-03 9:33 
GeneralDataTable.Select Pin
Ryan_Roberts28-Oct-03 2:41
Ryan_Roberts28-Oct-03 2:41 
GeneralPlease point me in the right direction... Pin
frank2127-Oct-03 9:00
frank2127-Oct-03 9:00 
GeneralRe: Please point me in the right direction... Pin
Aryo Handono31-Oct-03 3:15
professionalAryo Handono31-Oct-03 3:15 
Generalconnection pooling Pin
yyf27-Oct-03 7:59
yyf27-Oct-03 7:59 

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.