DB2 DATABASE

DB2 DATABASE

This is a blue board which means that it's for everybody (Safe For Work content only). If you see any adult content, please report it.

Thread replies: 7
Thread images: 1

Anonymous
DB2 DATABASE 2016-09-10 07:32:29 Post No. 56527276
[Report] Image search: [Google]

File: 1473409601092.png (12KB, 455x271px) Image search: [Google]

DB2 DATABASE Anonymous 2016-09-10 07:32:29 Post No. 56527276 [Report]

Pls teach me the correct way of using ALTDATE?. I can't get this to work.

When I use DATE, the format is mm/dd/yyyy.
I need it to be dd/mm/yyyy

Anonymous 2016-09-10 08:00:14 Post No.56527507
[Report]

Anonymous 2016-09-10 08:00:14 Post No.56527507 [Report]

Varchar_format(parcel_date, 'ddmmyyyy')

Anonymous 2016-09-10 09:53:49 Post No.56528448
[Report]

Anonymous 2016-09-10 09:53:49 Post No.56528448 [Report]

>>56527276
>MM/DD/YYYY

what the fuck is that
are you trying to confuse people
The ISO standard is YYYY-MM-DD

Anonymous 2016-09-10 10:08:37 Post No.56528593
[Report]

Anonymous 2016-09-10 10:08:37 Post No.56528593 [Report]

you asked this like 2 days ago already idiot learn to Google or something

Anonymous 2016-09-10 10:50:07 Post No.56528975
[Report]

Anonymous 2016-09-10 10:50:07 Post No.56528975 [Report]

>>56527507
so do I do it like this?
>parcel_date varchar_format(parcel_date, 'ddmmyyyy')

Anonymous 2016-09-10 11:03:44 Post No.56529102
[Report]

Anonymous 2016-09-10 11:03:44 Post No.56529102 [Report]

>>56528975
no

>The date can have one of the following formats:
>yyyy-mm-dd, mm-dd-yyyy, and mm/dd/yyyy

Anonymous 2016-09-10 13:40:10 Post No.56530567
[Report]

Anonymous 2016-09-10 13:40:10 Post No.56530567 [Report]

who gives a shit how its formated in the DB just format it in your client when you select it