Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: darrinlingle
- Order by date
-
Convert Date
ok. i found the two numbers: dateofinj is 2/4/2005 and the integer is 2453406. it's not obvious what formula is used just by looking at the two. any ideas?- darrinlingle
- Post #8
- Forum: Pervasive: Pervasive.SQL
-
Convert Date
oh. i didn't know CAST didn't work in my version. i tried the code to show the value of dateofinj and it's type 1. i don't know where i saw 16. is type 1 an integer? the program that created this is CompWatch. i cannot find any help on their site. it's frustrating because showing a field as a...- darrinlingle
- Post #6
- Forum: Pervasive: Pervasive.SQL
-
Convert Date
i'm using pervasive sql 2000i and have been working for hours on this small code. i'm trying to show a table's date of injury (dateofinj) 7 digit number field as a recognizable text/character date. doing "select dateofinj from cw02" gives me numbers like this : 2451893 i've tried: select...- darrinlingle
- Post #4
- Forum: Pervasive: Pervasive.SQL
