Content-Type: multipart/alternative;
 boundary="------------NlwdQKVJb5gaZU2G4KJDDsnf"
Message-ID: <01020192b98778c0-78365d74-1341-45c8-b0de-cc6b962afcf9-000000@eu-west-1.amazonses.com>
Date: Wed, 23 Oct 2024 13:18:36 +0000
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: CURRENTE_DATE
To: Rossana Ocampos <rocampos@bry-it.com>, 
	pgsql-general@lists.postgresql.org
References: <00b001db2475$e6584640$b308d2c0$@bry-it.com>
Content-Language: en-GB
From: Ray O'Donnell <ray@rodonnell.ie>
In-Reply-To: <00b001db2475$e6584640$b308d2c0$@bry-it.com>
Feedback-ID: ::1.eu-west-1.Bw1eu/7Uepg3xcsiFBL71JJRCh2A2yTFrgBhhiulXmU=:AmazonSES
Archived-At: <https://www.postgresql.org/message-id/01020192b98778c0-78365d74-1341-45c8-b0de-cc6b962afcf9-000000%40eu-west-1.amazonses.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------NlwdQKVJb5gaZU2G4KJDDsnf
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

On 22/10/2024 12:31, Rossana Ocampos wrote:
>
> *Hello ,*
>
> I am new with PostgreSQL and I have a bug. I have created a function 
> that has an input variable of type date , in case it does not receive 
> value , it has to assume by default the current date.
>
> I have defined it as follows variable  DATE DEFAULT CURRENT_DATE, but 
> I get the following error.
>
> *_El error _*
>
> ERROR: invalid input syntax for type date: “CURRENT_DATE” LINE 1: 
> ...extsupplydate ('1085018'::bigint, '5278'::bigint, 'CURRENT_D... ^ 
> ERROR: invalid input syntax for type date: “CURRENT_DATE” SQL status: 
> 22007 Characters: 78
>

I think you just need to leave off the quotes, as current_date is a 
function:

   insert into .... values ( ... , current_date, ....);

Also, you don't need to quote the bigint values.


HTH,

Ray.


> Please could you help me, thank you very much.
>
> Rossana
>


-- 
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie

--------------NlwdQKVJb5gaZU2G4KJDDsnf
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <div class="moz-cite-prefix">On 22/10/2024 12:31, Rossana Ocampos
      wrote:<br>
    </div>
    <blockquote type="cite"
      cite="mid:00b001db2475$e6584640$b308d2c0$@bry-it.com">
      <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
      <meta name="Generator"
        content="Microsoft Word 14 (filtered medium)">
      <style>@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri","sans-serif";
	mso-fareast-language:EN-US;}a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:blue;
	text-decoration:underline;}a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:purple;
	text-decoration:underline;}span.E-MailFormatvorlage17
	{mso-style-type:personal-compose;
	font-family:"Calibri","sans-serif";
	color:windowtext;}.MsoChpDefault
	{mso-style-type:export-only;
	font-family:"Calibri","sans-serif";
	mso-fareast-language:EN-US;}div.WordSection1
	{page:WordSection1;}</style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
      <div class="WordSection1">
        <p class="MsoNormal"><b><span lang="EN-US">Hello ,<o:p></o:p></span></b></p>
        <p class="MsoNormal"><span lang="EN-US">I am new with PostgreSQL
            and I have a bug. I have created a function that has an
            input variable of type date , in case it does not receive
            value , it has to assume by default the current date.<o:p></o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US">I have defined it as
            follows variable  DATE DEFAULT CURRENT_DATE, but I get the
            following error.<o:p></o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
        <p class="MsoNormal"><b><u><span lang="EN-US">El error <o:p></o:p></span></u></b></p>
        <p class="MsoNormal"><span lang="EN-US">ERROR: invalid input
            syntax for type date: “CURRENT_DATE” LINE 1:
            ...extsupplydate ('1085018'::bigint, '5278'::bigint,
            'CURRENT_D... ^ ERROR: invalid input syntax for type date:
            “CURRENT_DATE” SQL status: 22007 Characters: 78</span></p>
      </div>
    </blockquote>
    <br>
    I think you just need to leave off the quotes, as current_date is a
    function:<br>
    <br>
      insert into .... values ( ... , current_date, ....);<br>
    <br>
    Also, you don't need to quote the bigint values.<br>
    <br>
    <br>
    HTH,<br>
    <br>
    Ray.<br>
    <br>
    <br>
    <blockquote type="cite"
      cite="mid:00b001db2475$e6584640$b308d2c0$@bry-it.com">
      <div class="WordSection1">
        <p class="MsoNormal"><span lang="EN-US"><o:p></o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US">Please could you help
            me, thank you very much.<o:p></o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US">Rossana <o:p></o:p></span></p>
      </div>
    </blockquote>
    <br>
    <br>
    <pre class="moz-signature" cols="72">-- 
Raymond O'Donnell // Galway // Ireland
<a class="moz-txt-link-abbreviated" href="mailto:ray@rodonnell.ie">ray@rodonnell.ie</a></pre>
  </body>
</html>

--------------NlwdQKVJb5gaZU2G4KJDDsnf--