Regarding Timestamp
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
.
Relevant Pages
- Help required with Timestamp field
... the DB engine with its value in hex format. ... I just want to know is there any way to export these timestamp values ... into flat files in their numeric form as with years, months, dates etc? ...
(comp.databases.sybase) - Getting timestamp of flat files
... Is it possible through something like an ActiveX script task to ... get the timestamp on th e flat files? ... My DTS will read from the new ...
(microsoft.public.sqlserver.dts) - Re: identify changes for level 1 backup?
... Unfortunately this "timestamp" is not a "human timestamp". ... Whenever a level 0 backup starts, the backup utility starts to copy ALL the pages and the timestamp that was current at the begining of the backup is saved. ... Whenever a level 1 backup starts, the engine will read the pages, checking if it's timestamp is higher than the one saved when you did the level 0. ... This would allow you to see the most used partitions without too much overhead ...
(comp.databases.informix) - Re: Timestamp to ISO 8601
... Where CollectionData!TimeStamp is my timestamp field in another table and 7 ... > Hi Dave, ... > Dim strZulu As String ...
(microsoft.public.access.conversion) - Re: Help required with Timestamp field
... > the DB engine with its value in hex format. ... > I just want to know is there any way to export these timestamp values ... newsgroups if possible). ...
(comp.databases.sybase) |
|
