RE: SQL join date field with numeric field

[David FOXWELL <David.FOXWELL@xxxxxxxxx>]

Ah, you mean I needed 14 digits.

Thanks Birgitta, Sean.





> -----Message d'origine-----
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de Birgitta Hauser
> Envoyé : mardi 8 février 2011 15:38
> À : 'Midrange Systems Technical Discussion'
> Objet : AW: SQL join date field with numeric field
>
> The following snippet will convert an 8,0 numeric date in the 
> format YYYYMMDD into a real date:
>
> Date(Digits(MyNumFld) concat '000000')
>
> Mit freundlichen Grüßen / Best regards
>
> Birgitta Hauser
>
> "Shoot for the moon, even if you miss, you'll land among the 
> stars." (Les
> Brown)
> "If you think education is expensive, try ignorance." (Derek 
> Bok) "What is worse than training your staff and losing them? 
> Not training them and keeping them!"
>
> -----Ursprüngliche Nachricht-----
> Von: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von David FOXWELL
> Gesendet: Tuesday, 08. February 2011 15:25
> An: Midrange Systems Technical Discussion
> Betreff: SQL join date field with numeric field
>
> Hi,
>
> I need to join 2 tables, newtable and oldtable, using a date.
> In the old table, the date has been stored as a numeric value 
> like this :
> 20101231
>
> I could join by extracting the year month and day from the 
> new table and calculating a similar numeric representation, 
> but is there a way of using the date function on the numeric 
> value in the oldtable to give me a real date?
>
> Thanks
>
> --
> This is the Midrange Systems Technical Discussion 
> (MIDRANGE-L) mailing list To post a message email: 
> MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change 
> list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, 
> please take a moment to review the archives at 
> http://archive.midrange.com/midrange-l.
>
>
> -- 
> This is the Midrange Systems Technical Discussion 
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.