timestamp in C#

Posted by praveen on Stack Overflow See other posts from Stack Overflow or by praveen
Published on 2010-05-29T04:37:56Z Indexed on 2010/05/29 4:42 UTC
Read the original article Hit count: 170

Filed under:

c#

|

ssis-data-tranformations

Hi all,

I need to convert the system datetime to timestamp in script task SSIS.

input date format: 29/05/2010 2:36 AM

output format: 29-15-2010 14:36:00

thanks prav

© Stack Overflow or respective owner

Related posts about c#

.NET WebRequest.PreAuthenticate not quite what it sounds like

as seen on West-Wind - Search for 'West-Wind'
I’ve run into the problem a few times now: How to pre-authenticate .NET WebRequest calls doing an HTTP call to the server – essentially send authentication credentials on the very first request instead of waiting for a server challenge first? At first glance this sound like it should be easy:… >>> More
HttpWebRequest and Ignoring SSL Certificate Errors

as seen on West-Wind - Search for 'West-Wind'
Man I can't believe this. I'm still mucking around with OFX servers and it drives me absolutely crazy how some these servers are just so unbelievably misconfigured. I've recently hit three different 3 major brokerages which fail HTTP validation with bad or corrupt certificates at least according to… >>> More
The dynamic Type in C# Simplifies COM Member Access from Visual FoxPro

as seen on West-Wind - Search for 'West-Wind'
I’ve written quite a bit about Visual FoxPro interoperating with .NET in the past both for ASP.NET interacting with Visual FoxPro COM objects as well as Visual FoxPro calling into .NET code via COM Interop. COM Interop with Visual FoxPro has a number of problems but one of them at least got a lot… >>> More
Dynamic Type to do away with Reflection

as seen on West-Wind - Search for 'West-Wind'
The dynamic type in C# 4.0 is a welcome addition to the language. One thing I’ve been doing a lot with it is to remove explicit Reflection code that’s often necessary when you ‘dynamically’ need to walk and object hierarchy. In the past I’ve had a number of ReflectionUtils that used string based expressions… >>> More
Finding a Relative Path in .NET

as seen on West-Wind - Search for 'West-Wind'
Here’s a nice and simple path utility that I’ve needed in a number of applications: I need to find a relative path based on a base path. So if I’m working in a folder called c:\temp\templates\ and I want to find a relative path for c:\temp\templates\subdir\test.txt I want to receive back subdir\test… >>> More

Related posts about ssis-data-tranformations

SSIS how to split a single record in to two different records?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a Product record that has multiple "zoned" prices, one for each store that sells the product. ProductID int Name string PriceA money PriceB money PriceC money In SQL Server Integration Services, I need to split this in to multiple records: ProductID int Version string //… >>> More
script component

as seen on Stack Overflow - Search for 'Stack Overflow'
what is the use of script component in Data Flow ? Is it same as Script Task in Control flow ? Any difference ? >>> More
Error in retrieving data from Excel File

as seen on Stack Overflow - Search for 'Stack Overflow'
I have an excel file. I wanted to pull the data from excel file to SQL Server table. And the data is successfully transferred.In the excel file, I removed a text from one column named "Risk" from one row.The text was lengthy one.now the package execution fails at the source ie from the excel file… >>> More
Script Task - File Manipulation

as seen on Stack Overflow - Search for 'Stack Overflow'
Using Script Task, I have written a code to create a folder and create a file of msword document inside the created folder. Its working in local machine. But its not working in another server, after I deployed it. The folder is created successfully, but the word document file is not created. for word… >>> More
How can we abort the post in ProcessInputRow() event in SQL SSIS Script Component?

as seen on Stack Overflow - Search for 'Stack Overflow'
How can we abort the table post in this event: public override void Input0_ProcessInputRow(Input0Buffer Row) ... based on an input table field condition in our SSIS Script Component? For example if(Row.BoolValue) AbortPost(); We don't want to abort the whole process just this one record post… >>> More