FreeTDS Development Group

[Tim Uckun <tim AT diligence.com>]

At 10:35 AM 2/27/2001 -0800, you wrote:
> Errmmm... you do realize that a timestamp column is a binary(8) and
> that it has no relation to either time or date, right?

Yes I do.
It's not that I use them for anything but they exist in just about all of 
my tables because they were upsized from access. Because of that anytime I 
do a select * from anytable php crashes. I know it's not good form to do 
select * queries but alas I have inherited a complex web site with a ton of 
these.

BTW: According to the books online the timestamp datatype can be cast as 
just about anything except nvarchar, nchar, ntext and text.
I don't know how useful it is but there it is. For example

cast(upsize_ts as integer) as TS from tblreports where reportno=881211

gives you  34913591

I have no idea what this means but I bet there is a use for it.




> Michael
> --
> Michael Peppler - Data Migrations Inc. - mpeppler AT peppler.org
> http://www.mbay.net/~mpeppler - mpeppler AT mbay.net
> International Sybase User Group - http://www.isug.com
> Sybase on Linux mailing list: ase-linux-list AT isug.com
>
> ---
> You are currently subscribed to freetds as: [tim AT diligence.com]
> To unsubscribe, forward this message to 
> $subst('Email.Unsub')


:wq
Tim Uckun
Due Diligence Inc.  http://www.diligence.com/    Americas Background 
Investigation Expert.
If your company isn't doing background checks, maybe you haven't considered 
the risks of a bad hire.