i want to insert this in to a table which having datetime (as it is in log file) and the site visited.
I created a mysql table using DATE using the date type and the TIME suing time type.but once i loaded this log to table date field shows empty. like following.
I have two different table in a database in mysql that has no share key with each other and I want to sort them with each other on their date time column I mean when I sort it row X of table A that is older that row Y of table B comes earlier.
I set my location, but Debian displays DATE in some messed format. I would expect such neat OS to recognize all those local settings based on my location, but that's not the case. It seems that Debian follows locale settings by set language (which is en_us in my case, as I guess in majority uses) or this format is default in any case
I would like to set date/time to DD.MM.YY. hh:mm:ss, and programs that display date data to follow this setting. Simply put, in Windows there is Control Panel and you set location, then OS uses some regional settings, like currency, separators, date/time format.
In the past, I just edited the /usr/share/gnome-shell/js/ui/dateMenu.js file to alter the date and time format. Today when I tried that, it crashed GNOME Shell and wouldn't let it start..
I am using kde 4.4.4 and thunderbird. I would like to change how thunderbird shows the date. Now it is shown as 12.31.1980 and I would like to use 31.12.1980.
I am not sure if this is a thunderbird option (didnt find any) or a gtk option and how to configure that using kde.
I'm having an US American date format that drives me totally nuts, like MM/DD/YY. Today is 1/13/15. It seems to appear across the system (GNOME 3), from Skype to IceDove to Nautilus. So my hope is there is a central instance where I can change this. I would prefer to have 13-Jan-15 or 13-Jan-2015 or at the very least 13/01/2015, i.e. in some order consistent with my European brain.
After installing Evolution, the date format for entering birthdays was MDY. I edited the preferences and see under contacts it was set to "Use locale default" (which it identifies correctly, but should therefore have been using DMY).
I changed the format to a preset item in the drop-down selection to force it to %d.%m.%y %H:%M:%S which didn't change the birthday field behaviour. Have done the same in Calendar and Tasks, still no change.
if/where you can change the date format for the Birthday field in contacts in Evolution?
I have a document with page numbers in the Table of Contents in Roman Numurals. I would like to change them to numbers 1, 2, 3. How would I do this? I'm not finding any help on the Internet and in Openoffice help. If I change the numbers manually, they will revert back when I update the Table of Contents.
Kmail 1.13.2 Problem on startup, error is from nepomuk, data storage. "cannot find Redland backend, nepomuk is disabled until fixed. Also see the following error from the akonadi console:
100503 10:00:15 [Note] Plugin 'ndbcluster' is disabled. 100503 10:00:15 InnoDB: Started; log sequence number 0 31413862 100503 10:00:15 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without
I'm trying to setup wordpress on my server, which of course I need mysql for. I setup a database the other day, which worked perfectly, but I had to start again as I put some information in wrong. Now, I can create a database fine, but when I run
Code: GRANT ALL ON wordpress.* TO wordpress@localhost IDENTIFIED BY "password"; I get the output:
I have Fedora 15, with gnome and KDE core because I want to use Dolphin. The language of the OS is English so it shows dates in mm/dd/yyyy format. How can I get it to show dd/mm/yyyy or another format?
Is it possible to change the date format in Ubuntu 10.04 from the American mm/dd/yyyy to the British format of dd/mm/yyyy? I have looked at the Time/Date settings but cannot see any way of changing the date format
I have an unallocated space at the end of my hdd, which is about 10 gb. I installed Pardus on that space, but then deleted the partition to install something else (I know I did not have to delete it, I could simply install the new thing over it), i dont remember exactly how, but it was from my Debian System, not from a LiveCD.Now, I am unable to use that space. GParted gives an error and says:Warning: the kernel failed to re-read the partition tableon /dev/sda (Device or resource nusy). As a result, it may not reflect all of your changes until after reboot.
For some reason, thunderbird uses some random order for the date elements, e.g. MM/DD/YY. I need to change it to YYYY/MM/DD but haven't found where! There is no option in TB to configure this so I guess it just picks some default from regional settings? Where do I need to go to set the date format to its logical form?
I could find nothing on it. I want to change the date format for the clock in the upper right corner of the screen so that instead of reading [Wed 28 Apr, 11:51 AM] I will say [Wed 11:51 AM].
The date displayed in my panel is in the American format: Sat Jun 12, but my locale is set to Australian for everything. I have tried switching to different regions (System->Administration->Language Support), but this appears to have no effect on the date format.
In KWrite, you can make a datestamp and timestamp by pressing F7 for a command line and typing "date" therein. I just wondered: is it possible to change the stamp's date/time format, which is mm/dd/yy 24-hour time format? That's fine, but I wish the stamp could include the day of the week. (I use KWrite to keep a text-only personal journal. Any suggestions that I use a different program are welcome but are beside the point.)
I looked through the editor settings options, but found nothing relevant. The settings don't mention the F7 command line and the datestamp/timestamp at all; the only reason I know is because I once asked if there was a way to make one, as in Windows Notepad.
i want to know that how we can read date in format of 12/04/2010
in bash shell script
i mean , i want to read date form key board
i want that the user give input in the form of 12/04/2010 and then system varify that the entered date formate is correct or not. if it is valid , system will print echo " valid date" otherwise system will print echo "invalid date format"
I have 2 servers, 1 running a web server on 1 IP address,the other server running a proxy on a different IP address. I intend to change and update the ncsa file with usernames and passwords from a mysql table.Is there a way to replicate 1 table from the webserver to the proxy server databases and then run a cronjob? The cron will simply delete unused usernames and add new ones.Is there a better way of doing this? I don't want to run the webserver on the proxy server for security and also for performance.
I have just run into a baffling error. I have a database set up in MySQL with six tables. My PHP based website performs queries of all kinds on these tables (SELECT, INSERT, UPDATE, DELETE). On my most recently setup table, the "Orders" table, I am able to perform queries from the server, as well as from my PHP MySQL Admin interface, but all activity from my webpage states that the Orders table does not exist. All other tables are running fine. I have tried rewriting the query script, checked for case sensitivity problems, even cut and pasted other working scripts in place, changing the table and field names as needed. No success. What could cause a single table to not show up like this?
Just updated to natty last night, still coming to grips with Unity, but the date format for Sydney Australia shows as Year-Month-Day instead of Day-Month-Year, tried changing it manually, but it just changes it's self back to what it was. Still coming to grips with the launcher, but do not like the black back ground used in the dash, would like to be able to change it. Would also like to make the icons in the launcher smaller than 32.
I am trying to install some program: rosinfo: - Create mysql database for rosinfo - Create table hosts, locks. Use file docs/rosinfo.sqlAnd I need to create table hosts, locks, using file rosinfo.sql. I have that file, but dont know what to do with it.
I've started a webserver at 127.0.0.1:**** I want to be able to use a database for this server. Which schema do I use to add a new table to? Do I create a new Schema altogether?
When a user logs into my webmail application, it creates entries in a table on MySQL called "identities" which works great however once the user is deleted fro Linux with the "userdel -r" command, the data still sits in MySQL. My question is how I can I remove the table data from old users? It appears as show below:
I have been given some code and could not explain why it's err's out. Checked the mysql 5.0 manual but nothing[URL]. It only explains using UNION in a SELECT statement which I understand. If I drop off UNION=() then CREATE TABLE works fine.
I used a Kingston 8Gb flash drive as a live usb recently (copied the live iso image over using dd). I am done with the installations and all but seem to have a problem. i cannot format my flash drive. It now shows as a live CD (800 or so mb). Is there a way to fix the partition table back? I guess if i copy a partition table image from some other 8 gb drive that might fix the problem but i dont have any other flash drives. Is there a solution possible or am i stuck with a live usb forever
