473,320 Members | 1,863 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Showing "weekday, date (dd,mm,yyyy)" problem

Heey all!

I'm making an upload form, which will also add a date in the database. The date has to look like this format:
ex. Saturday, 26 January 2013
How can I do that? What type do I have to choose for the table row?

Thankss!
Jan 26 '13 #1
9 1628
Rabbit
12,516 Expert Mod 8TB
You want to store it as a date or datetime field. The display is just a formatting issue. You can display it however you want but you want to store it as a date or datetime.
Jan 26 '13 #2
Do you know what letter combination I have use for that?
Jan 27 '13 #3
Rabbit
12,516 Expert Mod 8TB
I don't know what you mean by letter combination.
Jan 28 '13 #4
ex. Saturday, 26 January 2013
the above example not support php mysql database
the correct format is YYYY-MM-DD
ex:2007-12-31
insert this format and select the values from database and change
it using explode or mktime
Jan 28 '13 #5
what is an explode or mktime? ..could you give me an example? I'm kinda new in the php/MySQL world..
Jan 28 '13 #6
with letter combination i mean for example: ("HH:MM:SS") or date("Y")
Jan 28 '13 #7
Rabbit
12,516 Expert Mod 8TB
So you're referring to the format string? Here is PHP's documentation of the DateTime::format function. http://php.net/manual/en/datetime.format.php
Jan 28 '13 #8
wel..the problem is more to display it in the format like: ex. Saturday, 26 January 2013

Someone has some php-code idea?
Jan 29 '13 #9
Rabbit
12,516 Expert Mod 8TB
There's an example of it in the link I gave you. Did you even read it?
Jan 29 '13 #10

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: jt | last post by:
Having a problem on trying to solve how to have the date and time displayed correctly and entered into my ms access database. I subscribe my web page being hosted remotely in Texas(CDT). I am...
2
by: Mark | last post by:
I have an Access 2000 database that pulls a file in everyday via the TransferText method. The file is named "psjrnl 25-Sep-2003.txt" (the 25-Sep-2003 will change and have the current days date). My...
8
by: Ishbel Kargar | last post by:
Since upgrading from old laptop (Windows 98) to new laptop (Windows XP), my mail-merge letters are doing strange things with date formats. For instance, my reminder letter for lapsed subs carries...
5
by: Ian Davies | last post by:
Dear Access expert I am trying to use an mde application developed in Access2k with Access 2002. I get an Access error box: Function is not available.. Date() etc. Is Access 2002 back...
7
by: Fred Flintstone | last post by:
I'm writing a VB.Net windows forms application. This line of code: Personal.EffectiveDate = GridRow2.Cells("New Value").Value.ToString.Trim Fails with this error: Cast from string...
2
by: Thomas Beyerlein | last post by:
I am binding dates to a textbox, the date is stored in SQL in a datetime field. When it gets bound it turns it into a long date (Sunday, Dec. 25 2005), in SQL when viewing the table it views as a...
1
by: zsolt | last post by:
Hi, I'm trying to convert a string to date by specifying the format. The value is like this: "03rd of April 2006". Now this is converted fine by using the following format: "dd\r\d \o\f MMMM...
10
by: Cylix | last post by:
I am going to define a date variable by specify a Date. How can I do so? I have tried below: var d = new Date(2006, 11, 30); //I expect this return 30 Dec 2006 but it shows "undefined-11-2006"...
2
by: siyoyok007 | last post by:
Hello, now i have two DTPicker, and one MS calendar, DTPicker1 is for the start date and DTPicker2 is for the end date. My problem is, how can i only enable only the date between DTPicker1 and...
1
by: jagalla | last post by:
Hi, Am Srinivas Jagalla, am getting error Date format. Whatever the format I provided in Local that is comming properly. when I uploaded in live there it isn't comming same format. ex: am...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.