Click here to Skip to main content
15,905,504 members
Home / Discussions / Database
   

Database

 
GeneralRe: (Actually it wasn't) Pin
Colin Angus Mackay7-Nov-03 1:37
Colin Angus Mackay7-Nov-03 1:37 
GeneralRe: (Actually it wasn't) Pin
Jörgen Sigvardsson7-Nov-03 3:11
Jörgen Sigvardsson7-Nov-03 3:11 
AnswerRe: Must be a permissions thing, but what? Pin
Giles7-Nov-03 3:49
Giles7-Nov-03 3:49 
GeneralRe: Must be a permissions thing, but what? Pin
Colin Angus Mackay7-Nov-03 5:10
Colin Angus Mackay7-Nov-03 5:10 
Generaldate Pin
Anonymous6-Nov-03 2:26
Anonymous6-Nov-03 2:26 
GeneralRe: date Pin
Colin Angus Mackay6-Nov-03 3:59
Colin Angus Mackay6-Nov-03 3:59 
GeneralRe: date Pin
Anonymous6-Nov-03 4:36
Anonymous6-Nov-03 4:36 
GeneralRe: date Pin
Colin Angus Mackay6-Nov-03 4:49
Colin Angus Mackay6-Nov-03 4:49 
CREATE TABLE [dbo].[my_date_table] (
[date1] [smalldatetime],
[date2] [smalldatetime] NULL,
[day1] AS (datepart(day, date1),
[month1] AS (datepart(month, date1),
[year1] AS (datepart(year, date1)/100),
[century1] AS (datepart(year, date1)%100)
[day2] AS (datepart(day, date2),
[month2] AS (datepart(month, date2),
[year2] AS (datepart(year, date2)/100),
[century2] AS (datepart(year, date2)%100)) ON [PRIMARY]

The SQL Server documentation has a lot of good information about manipulating dates. You can find more information there.



--Colin Mackay--

"In the confrontation between the stream and the rock, the stream always wins - not through strength but perseverance." (H. Jackson Brown)


GeneralSQL Statement question. Pin
theJazzyBrain6-Nov-03 1:25
theJazzyBrain6-Nov-03 1:25 
GeneralRe: SQL Statement question. Pin
Roger Wright6-Nov-03 3:24
professionalRoger Wright6-Nov-03 3:24 
GeneralRe: SQL Statement question. Pin
theJazzyBrain6-Nov-03 5:53
theJazzyBrain6-Nov-03 5:53 
GeneralRe: SQL Statement question. Pin
Jeff Varszegi6-Nov-03 6:57
professionalJeff Varszegi6-Nov-03 6:57 
GeneralRe: SQL Statement question. Pin
theJazzyBrain6-Nov-03 7:36
theJazzyBrain6-Nov-03 7:36 
GeneralRe: SQL Statement question. Pin
Jeff Varszegi6-Nov-03 7:39
professionalJeff Varszegi6-Nov-03 7:39 
GeneralRe: SQL Statement question. Pin
theJazzyBrain6-Nov-03 21:48
theJazzyBrain6-Nov-03 21:48 
GeneralRe: SQL Statement question. Pin
Jeff Varszegi7-Nov-03 2:43
professionalJeff Varszegi7-Nov-03 2:43 
GeneralRe: SQL Statement question. Pin
theJazzyBrain7-Nov-03 4:04
theJazzyBrain7-Nov-03 4:04 
Generaluser acces spermissions Pin
ranjjj6-Nov-03 0:10
ranjjj6-Nov-03 0:10 
GeneralRe: user acces spermissions Pin
perlmunger6-Nov-03 10:57
perlmunger6-Nov-03 10:57 
GeneralRe: user acces spermissions Pin
ranjjj6-Nov-03 17:36
ranjjj6-Nov-03 17:36 
GeneralRe: user acces spermissions Pin
perlmunger7-Nov-03 5:38
perlmunger7-Nov-03 5:38 
GeneralProblem in using OleDbDataReader Pin
sivaramakrishna5-Nov-03 22:14
sivaramakrishna5-Nov-03 22:14 
GeneralRe: Problem in using OleDbDataReader Pin
Mike Dimmick6-Nov-03 2:32
Mike Dimmick6-Nov-03 2:32 
GeneralRe: Problem in using OleDbDataReader Pin
sivaramakrishna7-Nov-03 19:06
sivaramakrishna7-Nov-03 19:06 
Generaldbo Pin
Hugo Hallman5-Nov-03 12:19
Hugo Hallman5-Nov-03 12:19 

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.