-
SQL DATE Format
I have one problem, when i made my table i made like this Ex.
create table table_name(buy_date date);
but it taked by defaul this format
date('yyyy-mm-dd');
i want in this formart
date('dd-mm-yyyy');
how can i do that?
-
You do date manipulations application side. You can manipulate the query to return the date in a specific format, but that slows the database down, so get all the results in your app, and then manipulate the date on the output stream.
Cheers
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|