by: Rick |
last post by:
I have been trying to run this MySQL query using PHP:
SELECT id, trans_type, remote_addr, DATE_FORMAT(time, '%M %e, %Y %r') as time
FROM transactions WHERE client_id = " . $client_id . " ORDER...
|
by: Johan den Boer |
last post by:
Hi,
What is wrong with this code ?
SELECT DATE_FORMAT( myfield, GET_FORMAT( TIMESTAMP, 'EUR' ) ) FROM T_TABLE;
regards
Johan
|
by: Jimmy |
last post by:
Hi,
I'm new to MySQL and I have qustion regarding to CAST and Date_Format
functions. I'm trying to convert a column 'Time' varchar(50) to
datetime datatype by "select date_format(cast(time as...
|
by: sang |
last post by:
Hai
I want to change the date format at the time of inserting the record.
i done it but one error in the insertion.
The query is
insert into mytable(update) values(date_format(...
|
by: sang |
last post by:
Hi
In my table the date format is changed to 06-feb-2007.The query i execute is
select date_format(col.name,"%e-%b-%Y") from tablename;
This is worked well in local but in the web it will...
|
by: adamalton |
last post by:
I am trying to take a date in the format "YYYY-MM-DD" and get from it the month as a word (e.g. July) and the day as a 2 digit number (e.g. 24).
I am trying to use the date_format function, (new...
|
by: laverdir |
last post by:
<?
$query = "SELECT " . $this->tabela3 . ".id, " . $this->tabela3 .
".naziv, " . $this->tabela3 . ".spisatelj, " . $this->tabela3 .
".najava, " . " DATE_FORMAT(" . $this->tabela3 ....
|
by: docscsi |
last post by:
Dear all
I'm quite new to mysql. My aim is to select a date format field by
returning only the month and day number of it (e.g. date = 11 12). I
got this statement and I could not get out how to...
|
by: ann86 |
last post by:
Hello,
I am a newbie to PHP and I am working on a site that was created by someone else. The server was updated yesterday so now I am getting the error
Fatal error: Cannot redeclare...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
1
