#1
  1. .Net Developer
    Devshed Novice (500 - 999 posts)

    Join Date
    Feb 2000
    Location
    London
    Posts
    987
    Rep Power
    15

    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!!

  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 1999
    Location
    Annapolis, Maryland US
    Posts
    113
    Rep Power
    15
    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...
  4. #3
  5. .Net Developer
    Devshed Novice (500 - 999 posts)

    Join Date
    Feb 2000
    Location
    London
    Posts
    987
    Rep Power
    15
    Thank You Kyuzo!!!

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


    Thanks for helping me...

Similar Threads

  1. Sort by my date format
    By Mickster in forum PHP Development
    Replies: 5
    Last Post: February 19th, 2004, 01:33 PM
  2. Empty date & date format
    By anca in forum Visual Basic Programming
    Replies: 2
    Last Post: February 17th, 2004, 04:38 AM
  3. inserting a date value into sql server (urgent!!)
    By icepricessa in forum ASP Programming
    Replies: 4
    Last Post: October 19th, 2003, 07:39 PM
  4. changing date format from 12/12/2002 to 12-12-2002
    By kimy_cool in forum PHP Development
    Replies: 5
    Last Post: September 19th, 2003, 02:35 PM
  5. What is the proper date format for a txt database?
    By jobesd in forum PHP Development
    Replies: 6
    Last Post: June 14th, 2001, 04:16 PM

IMN logo majestic logo threadwatch logo seochat tools logo