Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

Re: SSN's possible new Y2K problem?

by Stegalex (Chaplain)
on Aug 14, 2002 at 13:17 UTC ( [id://190056]=note: print w/replies, xml ) Need Help??


in reply to SSN's possible new Y2K problem?

2 points:
- SSN's *are* recycled.
- Even if they weren't, do you actually think that there will still be a Social Security sytem by the time they assign SSN 999-99-9999?


~~~~~~~~~~~~~~~
I like chicken.

Replies are listed 'Best First'.
Re: Re: SSN's possible new Y2K problem?
by krisahoch (Deacon) on Aug 14, 2002 at 16:19 UTC

    This is correct. They are recycled 25-50 years after a person's death (From SSN people here in Houston).

    Additionally if there are 1 billion active SSN's out there, then the 1 billonth would be alphanumeric 00a-000-0000

    Stick with VARCHAR(9)

    --Kristofer
    Updated: Forgot my p tags
      Additionally if there are 1 billion active SSN's out there, then the 1 billonth would be alphanumeric 00a-000-0000

      SSNs are not assigned sequentially, and certain digit sequences are considered invalid.

      The first three digits indicate in what state or administrative region the SSN was assigned, and the next two indicate in what group it was assigned. Here is an explanation.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://190056]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others learning in the Monastery: (5)
As of 2024-04-19 15:02 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found