PHP :: What MySQL Date / Time Type To Be Used In Apps And Why
Jan 9, 2011
I've always just kind of randomly chosen DateTime or TimeStamp. What are the pros/cons of each and what do you use and why? (I realize some have more detail, I'm usually looking for year/month/day/hour/minute/second resolution and I'm currently working with PHP, AS3, and Objective-C.
I'm kinda new to Flex and I'm using Flash Builder 4.5. I'm so frustrated.. Trying to solve this since yesterday morning and seems like there is just not enough resources to learn more about Flex! so here is the problem: I have a db field with a "date" DataType and i just can't order by it the xField! i tried so many things and nothing works.. when i try to order it by the id its working but its not supporting dates or something.
ok I have amfphp returning a query that is a Date data type in side of mysql. It is in this format "2007-27-5" which is a string. When making a date object in flash you need some thing like this
Code: var testDate:Date = new Date(2007, 4, 27); I would like to know if there is a short cut around this problem. As it would look now I need to take that string and have a regular expression pull the sub-strings ("2007", "5", "27") out and some how convert the sub-strings in to a numbers (2007, 5, 27), then set vars with the number latter sending it to that date constructor.
Anyone has experience to display the last log date from the mysql database to the flash?
i did it with the username - that was displaying but not the last_log_date anyone can profide suggestion or an easier method/solution? sample script would be coolz.
[Code]...
i read the data in actionscript with username_name and then display the data into the textfield. this worked for the username only but not for the last log date..
I retrieved the time from MySQL DateTime column and it's formatted just like this. "2010-04-30 04:12:07"How do I convert a MySQL DateTime so that I can display two seperate fields, I'd like to get "April, 30th, 2010" and "4:12 AM" separately.
I have a php page that sends xml compiled from data in a mysql table to my swf. The swf is actually an auction and I need to load in the' end time' of that item and do a date comparision for a countdown.
So what I'm asking for, in a nutshell, is for the best way to load in a date from a database in such a way that it can be used for date comparisons?
The mysql field is a datetime field. I can modify the format in php to whatever you feel in the best format (I need year, month,day,hour,min, seconds) - but I don't know what to do with the date once I have it in flash.
example xml: <Item end_time="2005-04-01 00:00:00" />
can I convert it into a valid date with out string manipulation? since the following doesn't work (obviously)
my_date = new Date(oXML.firstChild.attributes.end_time)
What I need is to be able to take the current time & substract it from the time in the xml to give me the remaining time.
I am using the function below to convert a Flash AS3 Date type to a MySQL- compatible 'datetime' string. It is working fine, BUT I am worried that AS3 may not extract the 'same date format' from different client computers thereby rendering my function useless.Is there a better way of passing date to MySQL? One that gaurantees consistancy.
public function getMySQLdate(flashDate:Date):String var year:String;var month:String;var day:String;var hours:String; var minutes:String;var seconds:String;
How to convert UTC time into date time format in flex. I am using sdk 3.5. for example I have current date time in UTC format as 1309522586000 (milliseconds) and I want to convert it to friday jul 1 2011. How can I do this??
I'm working on creating a new look for my portfolio and had a concept.I would like have one movie clip tween in real time 365 frame increments, while another moves in real time minute or second increments.Along with this, I would like to be able to override the passage of time by scrolling an associated scrollbar.The two tweens would be independent of one another.
I'm working on a large application that is broken up into many independent swfs. There is a master swf that loads a navigation shell and the foundational logic, and a module loading system that loads child swfs into the main display area. This is all working smoothly, and now I'm onto building the modules, and I'm starting to feel like my methods aren't as efficient as they should be. The module swfs (and corresponding flas) are located in a "modules" subdirectory of the main project's src folder. These modules share a large number of classes. In fact, most them define no new classes that are specific to just that module. The shared classes have a complicated structure of inheritance and interface usage, and are located in a view/structure subdirectory of the main src folder.
Currently, in order to use the shared classes from view/structure in my module swfs, I add the main project's src folder to the source path in each of the module flas. Besides being a bit tedious to do every time, it. 1.) Redundantly compiles the shared classes into each module increasing file sizes across the board, 2.) Requires addition of new source paths to the modules for every developer who wants to work on/test the application because they are absolute values and different on every os's file system, and 3.) Doesn't allow modules to be built independently without access to the main project src folder
Both of these are saved in files with the name same as the classes.
Both are saved a folder which also contains an fla file name hello.fla.So,when test the movie(hello.fla),after choosing the document class as WavyBall,I get these errors: 1046: Type was not found or was not a compile-time constant: Ball.
Source: var Ball:Ball; 1120: Access of undefined property stage. Source:Ball.x=stage.stageWidth/2; 1120: Access of undefined property stage. Source:Ball.y=stage.stageHeight/2; 5000: The class 'WavyBall' must subclass 'flash.display.MovieClip' since it is linked to a library symbol of that type.What is wrong?
I'm working on a large application that is broken up into many independent swfs. There is a master swf that loads a navigation shell and the foundational logic, and a module loading system that loads child swfs into the main display area. This is all working smoothly, and now I'm onto building the modules, and I'm starting to feel like my methods aren't as efficient as they should be.The module swfs (and corresponding flas) are located in a "modules" subdirectory of the main project's src folder. These modules share a large number of classes. In fact, most them define no new classes that are specific to just that module.The shared classes have a complicated structure of inheritance and interface usage, and are located in a view/structure subdirectory of the main src folder.
Currently, in order to use the shared classes from view/structure in my module swfs, I add the main project's src folder to the source path in each of the module flas. Besides being a bit tedious to do every time, it 1.) Redundantly compiles the shared classes into each module increasing file sizes across the board, 2.) Requires addition of new source paths to the modules for every developer who wants to work on/test the application because they are absolute values and different on every os's file system, and 3.) Doesn't allow modules to be built independently without access to the main project src folder.
I take a date (as a string data type) from the user. Now, I want to know if there is a a function in actionscript that will convert it to a date format. Right now, I am just parsing the string and concatenating the pieces back together. i.e.:
But for months like May, it will return "5" and not "05". I have similar problems for days like "9" or "7." Is there something in the library that will do this for me? (For the moment, I can go ahead and manually concatenate the "0" in front, but this seems like a hassle to do.)
I want to display 600 photos in a flash gallery. The user must be ble to add photos easily. They will preload load in sets of 12 thumbnails, clicking on a thumbnail will result in the larger photo loading. I would like to be able to arrange the photos by date, location and type of shot. I think I can create a photo class in actionscript with,
I have looked around a lot for the answer to this, here and out on the web, I just can't believe it can't be done.I have certificates that the user fills in their name once they successfully pass the on-line course, this works and prints fine. The decided they wanted the current date and time to show up on the certificate for their records. The date and time displays correctly, but when you go to print the certificate you get the default numerals, not the date and time, once the print dialogue box goes away after printing, you can see it change back to correct day and time.
I need to create a countdown timer to a date and time. I created a timer with the following code from a tutorial online. Problem is, I can't seem to figure out how to make it countdown to a time like 8am on that date. below is teh code I am working with. can anyone help me out?
this.onEnterFrame = function() { var today:Date = new Date(); var currentYear = today.getFullYear(); var currentTime = today.getTime(); var targetDate:Date = new Date(currentYear,05,13); var targetTime = targetDate.getTime(); var timeLeft = targetTime - currentTime; var sec = Math.floor(timeLeft/1000); var min = Math.floor(sec/60); var hrs =
I can get the current date in actionscript using the Date() function, my question is, does it give the same timezone for everyone? When I use it, it gives me the current hour and everything for the Eastern Time Zone (Newyork), but I live in Georgia, so I am eastern timezone, will someone who lives somewhere else, like california, run the code (below) and tell me if the time flash displays is the current time they have on their computer, or if the hours are off... with that said, if it is the same, and flash doesn't give everyone on earth the same time, is there any code I can use to retrieve the current time in 1 time zone no matter where on earth I am when I use the code? [code]
How would I modify this source if I wanted to have a one day then expire?I would like the source to use the time and/or date the swf was launched and count down to one work for one day.
I'm sorry to ask such a stupid question but the documentation is not clear to me. And I really don't want to screw it up. I am creating a flash piece that needs to change its content based on the date eastern time. so that the content on monday 00:00:00 will be different than the content sunday 11:59:59. I have everything set up for local time ie:
Code:var currentDate:Date = new Date();
But do to legal issues involved I need to set this up so that even if the user is in Alaska the content will change based on Eastern Standard Time.I'm sure I can use timeZoneOffset, but I'm just not sure how to implement it.
I have a map and want to be able to show the date and time on a few individual parts of the map. The date and time will display when the users roll-over the area of the map. There are about 10 different areas. Can someone tell me if that's possible.