[Help] SQL Databases

[ThisNameWillDo!]

Hey, when I add a field in a table on an SQL database, it automatically makes it yyyy-mm-dd, how can I make it dd-mm-yyyy?

Thanks,
Vince.

[Yonder]

Where are you adding this from directly in SQL or from a script of some sort?

[ThisNameWillDo!]

I'm adding it directly from mySQL.

[RastaLulz]

If you're doing it via PHP, it'd be:

<?php
$date = date("d-m-Y");
?>But if you're doing it via phpMyAdmin, I don't know, and I don't know why you'd be doing it that way..

[ThisNameWillDo!]

If you're doing it via PHP, it'd be:

<?php
$date = date("d-m-Y");
?>But if you're doing it via phpMyAdmin, I don't know, and I don't know why you'd be doing it that way..

Thanks but is there any way to insert the values for the date aswell, I don't want it to insert the current date, I want it to insert values someone has entered in the form (their date of birth).

Thanks,
Vince.

[Blinger$]

Would you just do three checks? To see if the first field is between 01-31, the second to check if the month is 01-12 and the year to be four digits.

[Chippiewill]

I don't think you can? Most of the time in php you can specify the order of the date queried from the MYSQL server.

[ThisNameWillDo!]

Well I've got a register form and in that form they have to enter their date of birth. One field is day of birth ($dayofbirth), one is month of birth ($monthofbirth) and one is year of birth ($yearofbirth). Then $dateofbirth = $yearofbirth - $monthofbirth - $dayofbirth. That works for me, and when I try and make it $dayofbirth - $monthofbirth - $yearofbirth it won't let me because it wants it YYYY-MM-DD, I'm just wondering if there's any way to change that?

Thanks,
Vince.

[Chippiewill]

Well I've got a register form and in that form they have to enter their date of birth. One field is day of birth ($dayofbirth), one is month of birth ($monthofbirth) and one is year of birth ($yearofbirth). Then $dateofbirth = $yearofbirth - $monthofbirth - $dayofbirth. That works for me, and when I try and make it $dayofbirth - $monthofbirth - $yearofbirth it won't let me because it wants it YYYY-MM-DD, I'm just wondering if there's any way to change that?

Thanks,
Vince.

I don't think there's a way to change how it's stored, you can change the order that it is outputted though, there are some dedicated PHP codes for that me thinks.

[Tomm]

You can't change how MySQL internally stores the data but it is not limited to accepting values in that format.

See here: http://dev.mysql.com/doc/refman/5.1/en/datetime.html for acceptable formats for DATE columns.

[Yonder]

Just use a plain text field in sql rather than a date one?

[ThisNameWillDo!]

I don't think there's a way to change how it's stored, you can change the order that it is outputted though, there are some dedicated PHP codes for that me thinks.

That would be fantastic, I'll have to research that, if anyone finds a way to output it to DD-MM-YYYY can you tell me please? Thanks!


You can't change how MySQL internally stores the data but it is not limited to accepting values in that format.

See here: http://dev.mysql.com/doc/refman/5.1/en/datetime.html for acceptable formats for DATE columns.

Thank you very much.


Just use a plain text field in sql rather than a date one?

I want to make sure it's a date field because I'm going to do ages checks etc. later on.