varchar to timestamp/bigint ?

• sam2003xyz

  SSC Journeyman

  Points: 91

  More actions

  July 2, 2003 at 8:33 am

  #160269

  I need to convert data in varchar to timestamp or bigint, is it possible ?

  Or else can i use any other technique.

  I tried using cast(varchat_value as timestamp) but it changes the value!

• SQLBill

  SSC Guru

  Points: 51440

  More actions

  July 2, 2003 at 10:10 am

  #463953

  What does the VARCHAR data look like? BIGINT does not allow decimals.

  SQL's TIMESTAMP is really used to 'version stamp table rows'. Read up on this in the Books Online (BOL).

  If your VARCHAR column is strictly integers, try this (change 'mycolumn' to whatever your column name is):

  convert(bigint, mycolumn)

  Refer to the BOL for more information on the various datatypes.

  -SQLBill