★ wanayoo — archive 1999 http://www.devshed.com/Talk/Forums/Forum4/HTML/000278.htmlNouvelle recherche | Portail wanayoo
DevShed Menu
* DevShed Home
* Developer News
* DevShed Brain Dump




UBBFriend: Email This Page to Someone!
   DevShed Discussion Forums
  MySQL
  Date format----"mm-dd"--Urgent!!!

Post New Topic  Post A Reply
profile | register | preferences | faq | search

next newest topic | next oldest topic
Author Topic:   Date format----"mm-dd"--Urgent!!!
Shiju Rajan
Member 		posted February 22, 2000 11:25 PM     Click Here to See the Profile for Shiju Rajan   Click Here to Email Shiju Rajan     Edit/Delete Message Reply w/Quote

can i save date in "mm-dd" format in the database field?,

Is it possible to take differnece between current date("mm-dd") and that datafield date?..


Please give an answer !!!

very urgent!!

Kyuzo
Member 		posted February 23, 2000 07:12 AM     Click Here to See the Profile for Kyuzo   Click Here to Email Kyuzo     Edit/Delete Message Reply w/Quote
You might want to store the date field as DATE or TIMESTAMP type and use MySQL's to_days and date_format functions for date arithmetic and formatting, respectively. Check MySQL's online manual for more info...

Shiju Rajan
Member 		posted February 24, 2000 03:38 AM     Click Here to See the Profile for Shiju Rajan   Click Here to Email Shiju Rajan     Edit/Delete Message Reply w/Quote
Thank You Kyuzo!!!

I got some notes about dateformatting.
After testing the script i'll tell you the result.


Thanks for helping me...

All times are MST (US)

next newest topic | next oldest topic

Administrative Options: Close Topic | Archive/Move | Delete Topic
Post New Topic  Post A Reply
Hop to:

Contact Us | DevShed.com

Copyright © 1997-2000 ngenuity. All rights reserved.

Powered by: Ultimate Bulletin Board, Version 5.41a
© Infopop Corporation (formerly Madrona Park, Inc.), 1998 - 1999.