Members Login.
 

Please register HERE to be part of our Community
Latest Discussions ...
 

New topics in mySQL Database
Contest of the Day.
 
Current Promotions.
 
Refer your friends to this forum and earn BRL per referred member.

Post a New Thread anywhere on Web Development Board to earn BRL$ 5 for every thread. Post a New Reply there and earn BRL$ 3 for every reply.

Post a New Thread anywhere on Search Engine Optimization Board and earn BRL$ 5 for every thread.
Earn By Posting
 
Participate in forum and Earn $$$.

Get Referrer Credit - BRL$ 20
Get Positive Rep Cr. - BRL$ 3
Get New Thread Cr.- BRL$ 3
Get Posting Cr. - BRL$ 2
Get Post size Credit

Full List of BRL$ Earnings
Sponsors.
 


mySQL Database Discussion related to mySQL database, mySQL queries, mySQL Commands, mySQL tutorials...

   

MySQL General: Storing dates in the billions of years


This is a discussion on MySQL General: Storing dates in the billions of years within the mySQL Database forums, part of the Database category; Hi- I am looking to implement a date format that could possibly include dates in the billions of years.Since ...

Reply
  #1 (permalink)  
Old 07-09-2007
Senior Member

Join Date: Jun 2007
Posts: 1,399
BRL$: 4,187.66
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 173
mr_atom is on a distinguished road
Default MySQL General: Storing dates in the billions of years

Hi- I am looking to implement a date format that could possibly include dates in the billions of years.Since the datetime format only allows dates between 1000-9999 I won't be able to use this directly. I am considering using perhaps an integer or som


To view links or images in this forum your post count must be 1 or greater. You currently have 0 posts.
__________________

To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.


To receive latest updates about BRL Forums, Subscribe to Latest Updates Thread.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Tags
billions, dates, general, mysql, storing, years


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL General: New to PHP mr_atom mySQL Database 0 07-09-2007 07:03 AM
MySQL General: problem with create table statement mr_atom mySQL Database 0 07-09-2007 07:03 AM
MySQL General: CREATE USER vs. GRANT ALL PRIVILEGES ON *.* TO mr_atom mySQL Database 0 07-09-2007 07:03 AM
MySQL General: Help: Unable to start MySQL in linux mr_atom mySQL Database 0 07-09-2007 07:03 AM
MySQL General: mysqldump problem mr_atom mySQL Database 0 07-09-2007 07:03 AM


 

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105