Re: Regarding Timestamp



pankaj_wolfhunter@xxxxxxxxxxx wrote:

Greetings,
                This may be very basic but i still would like to ask
this.
I have a table with a timestamp field that gets updated by the DB
engine.

select * from test
go

id          timestamp_value
 ----------- ------------------
           1 0x00000000003da03b

(1 row affected)

If i try to bcp out the content of this table into flat files, the
content appears as below

1|00000000003da03b

The "x" from the timestamp value is not getting exported out.

How can i make the entire timestamp value to be exported to flat files
without truncating anything?

Any help would be appreciated.

TIA 

Hi. In fact the '0x' is not part of the data. It is just a syntactical
tag, added by ISQL in output, and needed to parse inputs or other
Sybase-supplied query tool. The data itself is a small binary column
with exactly the data you see in the BCP file. It is put that way in
the BCP file, and expected to be that way by BCP when it goes back in
to the DBMS via BCP. In other words, BCP doesn't need or want the extra
hint about the column type attached to the data. If you want to convert
BCP files to input for ISQL etc, you would have to add it yourself.
HTH,
Joe Weinstein at BEA Systems

.

Relevant Pages

  • Best Way to Update Table?
    ... Use BCP to extact the data to a text file then write perl ... program to update the BCP file. ... brake the table into 4 tables and then process ...
    (microsoft.public.sqlserver.mseq)
  • create a table prior to bcping data
    ... bcp out data from our reporting server ... Move bcp file to our archival server ...
    (microsoft.public.sqlserver.server)
  • Re: Lookup specific string in all-tables
    ... trick. ... regarding to your valuable solution. ... You can bcp the rows out of the table, no matter how big it is AFAIK. ... The bcp file for a larger table might be ...
    (comp.databases.sybase)