Re: Store a process number with date
From: Stefan Ram <ram_at_zedat.fu-berlin.de>
Date: 2 Feb 2015 13:50:04 GMT
Message-ID: <concat-20150202144954_at_ram.dialup.fu-berlin.de>
Date: 2 Feb 2015 13:50:04 GMT
Message-ID: <concat-20150202144954_at_ram.dialup.fu-berlin.de>
Álesson David Gomes Nunes <alesdavidgomes_at_gmail.com> writes:
>But I need a things like that 20150201xxx where xxx is a
>number auto incremented, the "id_" of this table, for example.
something along the lines of
select concat(year(b),month(b),day(b),a) from a;
Received on Mon Feb 02 2015 - 14:50:04 CET