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 |
|
maihabib
Starting Member
22 Posts |
 Posted - 2014-02-04 : 04:43:36
|
| i have a datetime variable in a ssis package.i created a job to run this package.now i want to set the value of this variable in the job.how do i write the date. give me example please.is it '20121230'or 2012-12-30 or what?thanks, |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2014-02-04 : 05:53:10
|
'20121230' is best if you want to have the time part all zero.
Too old to Rock'n'Roll too young to die. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-02-04 : 07:22:49
|
quote:
Originally posted by maihabib
i have a datetime variable in a ssis package.i created a job to run this package.now i want to set the value of this variable in the job.how do i write the date. give me example please.is it '20121230'or 2012-12-30 or what?thanks,
seehttp://visakhm.blogspot.com/2011/12/why-iso-format-is-recommended-while.html------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
what's the correct datetime format to set a dateti