Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2009-04-17 : 11:12:39
|
| hi i have a column of type integer that called CDATE.i have value like :61718406173280it's mean the minute from '1988-01-01 00:00:00.0'i write this expression in DERIVED column:DATEADD("mi",'1988-01-01 00:00:00.0',CURDATE) i choose Date type as date[DT_Date] .and i get a ERROR that he have problem with expression,what is solution? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-04-17 : 11:29:54
|
| shouldnt it be?DATEADD("mi",CURDATE,'1988-01-01 00:00:00.0') |
 |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2009-04-18 : 13:14:06
|
| it should be but it is not like the '1988-01-01 00:00:00.0' |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-04-18 : 15:16:02
|
| sorry didnt get that . did you try casting it to date? |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2009-04-18 : 15:27:24
|
| thanks i write this:DATEADD("mi",CURDATE,(DT_DATE)"1988-01-01") |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-04-18 : 15:40:33
|
| welcome |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
DateAdd in SSIS