Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 04-08-2009
Member
 
Join Date: Apr 2009
Posts: 17
C# timestamp datatype

HI,

I want to know if there is any datatype in C# that allows return of timestamp? I'm accessing stored proc that expects a timestamp input parameter. Can anyone help me with this?
Reply With Quote
  #2  
Old 04-08-2009
Member
 
Join Date: May 2008
Posts: 2,383
Re: C# timestamp datatype

Can you be more specific with your question? Have you tried the plain DateTime data type?
__________________
The FIFA Manager 2009 PC Game
Reply With Quote
  #3  
Old 04-08-2009
Member
 
Join Date: Mar 2008
Posts: 198
Re: C# timestamp datatype

A timestamp as in SQL timestamp? For your knowledge "timestamp" is the same as varbinary(8), just except for the automatic update behavior.

The timestamp in SQL Server maps to a Byte[] type in .NET framework. byte[] - i.e. an array of bytes. It is not used as DateTime. If you just need to store date/time information, try to use datetime data type, it maps to a DateTime object in .NET framework. The SQL TimeStamp is fully based on insert / update order on your sql server.
Reply With Quote
  #4  
Old 04-08-2009
Member
 
Join Date: Dec 2008
Posts: 1,108
Re: C# timestamp datatype

Refer to following links , see if they helps you:

http://msdn.microsoft.com/en-us/library/ms182776.aspx
http://msdn.microsoft.com/en-us/libr...8VS.71%29.aspx

Hope this will hep.
__________________
The difference between stupidity and genius is that genius has its limits. - Albert Einstein

What we think, we become (Please don't think you are a superhero and don't try to fly)

"SUCCESS IS NOT A DESTINATION , IT'S A JOURNEY"
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "C# timestamp datatype"
Thread Thread Starter Forum Replies Last Post
Changing the entity of a datatype GOOL Software Development 6 06-01-2011 08:31 AM
Change double datatype in parameter ISAIAH Software Development 5 08-03-2010 09:24 AM
BLOB datatype in oracle database Garlands Software Development 4 10-02-2010 10:53 PM
What is Timestamp in SQL? Shekhar12 Software Development 4 30-11-2009 10:02 AM
DataType Decimal or double for Currency? ArunJ Software Development 4 14-02-2009 06:54 PM


All times are GMT +5.5. The time now is 12:42 PM.