On Wed, Oct 16, 2013 at 9:32 PM, Dan Covill <[email protected]> wrote:
> On 10/16/13 06:17 PM, Kent Belan wrote: > >> Here is my question: >> The date fields are coming over as character in 2013-10-16 format. Is >> there >> a way to get date fields or do I have to convert them ? >> >> The first thing you need to do is to look at the specification of the > database. I'd guess that what you're getting means that the dates are > stored as character strings, but there's nothing like knowing. > > What I'm trying to say is find out exactly what you've got FIRST, then > figure out what you need, and then you can worry about how to do it. > > Same with .NULL.s. FACT: They're in the data. FACT: There are several > easy ways to deal with them. UNKNOWN: What does the application WANT you > to do with them? > -------------- Are you expected to not screw with the null values? If you convert to spaces will it throw off the other system if you do an update? -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajidmyk7kn7txngcgsxnjiwupuzd1skt835u2hkz5huw_ay...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
